Skip Headers

Oracle® Database Administrator's Guide 10g Release 2 (10.2) Part Number B14231-01 |
Home | Book List | Contents | Master Index | Feedback

Previous
| View PDF

# Index

A B C D E F G H I J K L M N O P Q R S T U V W X

## A

  abort response, 32.3.1.1.3
    two-phase commit, 32.3.1.1.3
  accounts
    DBA operating system account, 1.5.1
    users SYS and SYSTEM, 1.5.2
  ADD LOGFILE clause
    ALTER DATABASE statement, 6.3.1
  ADD LOGFILE MEMBER clause
    ALTER DATABASE statement, 6.3.2
  ADD PARTITION clause, 17.4.2.1
  ADD SUBPARTITION clause, 17.4.2.4.2, 17.4.2.5.2
  adding
    templates to a disk group, 12.4.10.1
  ADMIN_TABLES procedure
    creating admin table, 21.3.1.1
    DBMS_REPAIR package, 21.2.1
    example, 21.4.1.1, 21.4.1.2
  ADMINISTER_RESOURCE_MANAGER system privilege, 24.2
  administering
    disk groups, 12.4
  administration
    distributed databases, 30
  AFTER SUSPEND system event, 14.4.4.1
  AFTER SUSPEND trigger, 14.4.4.1
    example of registering, 14.4.6
  agent
    Heterogeneous Services, definition of, 29.1.2
  aggregate functions
    statement transparency in distributed databases, 30.7
  alert log
    about, 4.7.2
    location of, 4.7.2.2
    size of, 4.7.2.3
    using, 4.7.2
    when written, 4.7.2.4
  alert thresholds
    setting for locally managed tablespaces, 14.1.1
  alerts
    server-generated, 4.7.1
    threshold-based, 4.7.1
    viewing, 14.1.2
  aliases
    dropping from a disk group, 12.4.9
  aliases, managing Automatic Storage Management, 12.4.8
  ALL_DB_LINKS view, 30.5.1, 30.5.1
  allocation
    extents, 15.6.4
  ALTER CLUSTER statement
    ALLOCATE EXTENT clause, 18.4
    using for hash clusters, 19.4
    using for index clusters, 18.4
  ALTER DATABASE ADD LOGFILE statement
    using Oracle-managed files, 11.3.6.1
  ALTER DATABASE statement
    ADD LOGFILE clause, 6.3.1
    ADD LOGFILE MEMBER clause, 6.3.2
    ARCHIVELOG clause, 7.3.2
    CLEAR LOGFILE clause, 6.8
    CLEAR UNARCHIVED LOGFILE clause, 6.2.1.1
    database partially available to users, 3.2.1
    DATAFILE...OFFLINE DROP clause, 9.4.2
    datafiles online or offline, 9.4.3
    default temporary tablespace, specifying, 2.3.6
    DROP LOGFILE clause, 6.5.1
    DROP LOGFILE MEMBER clause, 6.5.2
    MOUNT clause, 3.2.1
    NOARCHIVELOG clause, 7.3.2
    OPEN clause, 3.2.2
    READ ONLY clause, 3.2.3
    RENAME FILE clause, 9.5.2
    tempfiles online or offline, 9.4.3
    UNRECOVERABLE DATAFILE clause, 6.8
  ALTER DISKGROUP command, 12.4.3
  ALTER FUNCTION statement
    COMPILE clause, 13.7.2
  ALTER INDEX statement
    COALESCE clause, 16.2.10
    for maintaining partitioned indexes, 17.4
    MONITORING USAGE clause, 16.4.3
  ALTER PACKAGE statement
    COMPILE clause, 13.7.3
  ALTER PROCEDURE statement
    COMPILE clause, 13.7.2
  ALTER SEQUENCE statement, 20.2.3
  ALTER SESSION
    Enabling resumable space allocation, 14.4.2.2
  ALTER SESSION statement
    ADVISE clause, 33.4.3.3
    CLOSE DATABASE LINK clause, 31.2
    SET SQL_TRACE initialization parameter, 4.7.2.4
    setting time zone, 2.3.9.1
  ALTER SYSTEM statement
    ARCHIVE LOG ALL clause, 7.3.3
    DISABLE DISTRIBUTED RECOVERY clause, 33.9.2
    ENABLE DISTRIBUTED RECOVERY clause, 33.9.2
    ENABLE RESTRICTED SESSION clause, 3.2.4
    enabling Database Resource Manager, 24.6
    QUIESCE RESTRICTED, 3.4.1
    RESUME clause, 3.5
    SCOPE clause for SET, 2.7.5.1
    SET RESOURCE_MANAGER_PLAN, 24.6
    SET SHARED_SERVERS initialization parameter, 4.2.2.2
    setting initialization parameters, 2.7.5
    SUSPEND clause, 3.5
    SWITCH LOGFILE clause, 6.6
    UNQUIESCE, 3.4.2
  ALTER TABLE
    MODIFY DEFAULT ATTRIBUTES FOR PARTITION clause, 17.4.7.2, 17.4.7.3
  ALTER TABLE statement
    ADD (column) clause, 15.6.6
    ALLOCATE EXTENT clause, 15.6.4
    DEALLOCATE UNUSED clause, 15.6.4
    DISABLE ALL TRIGGERS clause, 13.4.2
    DISABLE integrity constraint clause, 13.5.3.1
    DROP COLUMN clause, 15.6.8.1
    DROP integrity constraint clause, 13.5.3.3
    DROP UNUSED COLUMNS clause, 15.6.8.2
    ENABLE ALL TRIGGERS clause, 13.4.1
    ENABLE integrity constraint clause, 13.5.3.1, 13.5.3.1
    external tables, 15.13.2
    for maintaining partitions, 17.4
    MODIFY (column) clause, 15.6.5
    MODIFY DEFAULT ATTRIBUTES clause, 17.4.7.1
    modifying index-organized table attributes, 15.12.3.1
    MOVE clause, 15.6.3, 15.6.3, 15.12.3.2
    reasons for use, 15.6.1
    RENAME COLUMN clause, 15.6.7
    SET UNUSED clause, 15.6.8.2
  ALTER TABLESPACE statement
    adding an Oracle-managed datafile, example, 11.3.3.3
    adding an Oracle-managed tempfile, example, 11.3.4.2
    ONLINE clause, example, 8.5.2
    READ ONLY clause, 8.6.1
    READ WRITE clause, 8.6.2
    RENAME DATAFILE clause, 9.5.1.1
    RENAME TO clause, 8.7
    taking datafiles/tempfiles online/offline, 9.4.3
  ALTER TRIGGER statement
    DISABLE clause, 13.4.2
    ENABLE clause, 13.4.1
  ALTER VIEW statement
    COMPILE clause, 13.7.1
  altering
    (Scheduler) windows, 27.6.3
    chain steps, 27.9.12
    event schedule, 27.8.2.4
    event-based job, 27.8.2.2
    job classes, 27.5.3
    jobs, 27.2.4
    programs, 27.3.3
    schedules, 27.4.3
  altering indexes, 16.4, 16.4.2
  ANALYZE statement
    CASCADE clause, 13.2.2
    corruption reporting, 21.3.1.3
    listing chained rows, 13.2.3
    remote tables, 31.4.2.2.2
    validating structure, 13.2.2, 21.3.1
  analyzing schema objects, 13.2
  analyzing tables
    distributed processing, 31.4.2.2.2
  application development
    distributed databases, 29.5, 31, 31.5
  application development for distributed databases, 31
    analyzing execution plan, 31.4.4
    database links, controlling connections, 31.2
    handling errors, 31.3, 31.5
    handling remote procedure errors, 31.5
    managing distribution of data, 31.1
    managing referential integrity constraints, 31.3
    terminating remote connections, 31.2
    tuning distributed queries, 31.4
    tuning using collocated inline views, 31.4.1
    using cost-based optimization, 31.4.2
    using hints to tune queries, 31.4.3
  application services
    configuring, 2.8.2
    defining, 2.8
    deploying, 2.8.1
    using, 2.8.3
    using, client side, 2.8.3.1
    using, server side, 2.8.3.2
  archive log files
    creating in Automatic Storage Management, 12.5.9
  ARCHIVE_LAG_TARGET initialization parameter, 6.2.5.1
  archived redo logs
    archiving modes, 7.3.2
    destination availability state, controlling, 7.4.2
    destination status, 7.4.2
    destinations, specifying, 7.4
    failed destinations and, 7.6
    mandatory destinations, 7.6.1.1
    minimum number of destinations, 7.6.1
    multiplexing, 7.4.1
    normal transmission of, 7.5
    re-archiving to failed destination, 7.6.2
    sample destination scenarios, 7.6.1.2
    standby transmission of, 7.5
    status information, 7.8.1
    transmitting, 7.5
  ARCHIVELOG mode, 7.2.2
    advantages, 7.2.2
    archiving, 7.2
    automatic archiving in, 7.2.2
    definition of, 7.2.2
    distributed databases, 7.2.2
    enabling, 7.3.2
    manual archiving in, 7.2.2
    running in, 7.2.2
    switching to, 7.3.2
    taking datafiles offline and online in, 9.4.1
  archiver process
    trace output (controlling), 7.7
  archiver process (ARCn), 4.3
  archiving
    changing archiving mode, 7.3.2
    controlling number of processes, 7.3.4
    destination availability state, controlling, 7.4.2
    destination failure, 7.6
    destination status, 7.4.2
    manual, 7.3.3, 7.3.3
    NOARCHIVELOG vs. ARCHIVELOG mode, 7.2
    setting initial mode, 7.3.1
    to failed destinations, 7.6.2
    trace output, controlling, 7.7
    viewing information on, 7.8.1
  ASM
    see Automatic Storage Management
  ASM_DISKGROUPS, 12.3.3.1
  ASM_DISKSTRING, 12.3.3.1
  ASM_POWER_LIMIT, 12.3.3.1
  ASMLib, 12.3.1
  auditing
    database links, 29.3.3
  authentication
    database links, 29.3.2.1
    operating system, 1.6.3.2
    selecting a method, 1.6.2
    using password file, 1.6.4.1
  AUTO_TASK_CONSUMER_GROUP
    of Resource Manager, 23.3
  AUTOEXTEND clause
    for bigfile tablespaces, 8.2.2.2
  automatic segment space management, 8.2.1.2
  Automatic Storage Management
    accessing files with the XML DB virtual folder, 12.7
    administering, 12.3
    aliases, 12.4.8
    authentication, 12.3.2
    creating a database in, 12.5.5
    creating archive log files in, 12.5.9
    creating control file in, 12.5.8
    creating files in the database, 12.5.4
    creating redo logs in, 12.5.7
    creating tablespaces in, 12.5.6
    disk discovery, 12.2, 12.3.4.3
    disk failures in, 12.4.1.4
    filenames, 12.5.2
    initialization files and, 3.1.2
    initialization parameters, 12.3.3, 12.3.3.1
    installation tips, 12.3.1
    installing, 12.3.1
    migrating a database to, 12.6
    operating system authentication for, 12.3.2.1
    overview, 12.1
    overview of components, 12.2
    password file authentication for, 12.3.2.2
    shutting down, 12.3.5
    starting up, 12.3.4
    using in database, 12.5
    views, 12.8
    XML DB virtual folder, 12.7
  automatic undo management, 2.3.4, 10.2

## B

  background processes, 4.3
    FMON, 9.9.2.1.1
  BACKGROUND_DUMP_DEST initialization parameter, 4.7.2.2
  backups
    after creating new databases, 2.2.2.11
    effects of archiving on, 7.2.1
  batch jobs, authenticating users in, 2.9.3
  bigfile tablespaces
    creating, 8.2.2.1
    creating temporary, 8.2.3.2
    description, 8.2.2
    setting database default, 2.3.8.1
  BLANK_TRIMMING initialization parameter, 15.6.5
  BLOCKSIZE clause
    of CREATE TABLESPACE, 8.3
  BUFFER_POOL parameter
    description, 14.3.1
  buffers
    buffer cache in SGA, 2.4.5.4.1

## C

  CACHE option
    CREATE SEQUENCE statement, 20.2.4.2.2
  caches
    sequence numbers, 20.2.4.2
  calendaring expressions, 27.4.5.1
  calls
    remote procedure, 29.5.2
  capacity planning
    space management
      capacity planning, 14.8
  capacity, managing in disk groups, 12.4.1.6
  CASCADE clause
    when dropping unique or primary keys, 13.5.3.1
  CATBLOCK.SQL script, 4.7.3
  centralized user management
    distributed systems, 29.3.2.4
  chain rules, 27.9.4
  chain steps
    defining, 27.9.3
  chained rows
    eliminating from table, procedure, 13.2.3.2
  CHAINED_ROWS table
    used by ANALYZE statement, 13.2.3.1
  chains
    creating, 27.9.2
    creating jobs for, 27.9.6
    disabling, 27.9.10
    dropping, 27.9.7
    dropping rules from, 27.9.9
    enabling, 27.9.5
    monitoring, 28.2.13
    overview, 26.2.5
    running, 27.9.8
    stalled, 27.9.13
    using, 27.9
  change vectors, 6.1.2
  CHAR datatype
    increasing column length, 15.6.5
  character set
    choosing, 2.2.1.1
  CHECK_OBJECT procedure
    DBMS_REPAIR package, 21.2.1
    example, 21.4.2
    finding extent of corruption, 21.3.2
  checkpoint process (CKPT), 4.3
  checksums
    for data blocks, 9.7
    redo log blocks, 6.7, 6.7
  CLEAR LOGFILE clause
    ALTER DATABASE statement, 6.8, 6.8
  clearing redo log files, 6.2.1.1, 6.8
  client/server architectures
    distributed databases, 29.1.3, 29.1.3
    globalization support, 29.6.1
  cloning
    a database, 1.2.11
    an Oracle home, 1.2.11
  CLOSE DATABASE LINK clause
    ALTER SESSION statement, 31.2
  closing database links, 30.4.1
  closing windows, 27.6.5
  clusters
    about, 18.1
    allocating extents, 18.4
    altering, 18.4
    analyzing, 13.2
    cluster indexes, 18.5
    cluster keys, 18.1, 18.2.2, 18.2.3
    clustered tables, 18.1, 18.2.1, 18.3.1, 18.4.1, 18.5.1
    columns for cluster key, 18.2.2
    creating, 18.3
    deallocating extents, 18.4
    dropping, 18.5
    estimating space, 18.2.3, 18.2.5
    guidelines for managing, 18.2, 18.2.5
    hash clusters, 19
    location, 18.2.4
    privileges, 18.3, 18.4, 18.5.1
    selecting tables, 18.2.1
    single-table hash clusters, 19.3.2
    sorted hash, 19.3.1
    truncating, 13.3
    validating structure, 13.2.2
  COALESCE PARTITION clause, 17.4.3.1
  coalescing indexes
    costs, 16.2.10
  collocated inline views
    tuning distributed queries, 31.4.1
  column encryption, 2.9.2
  columns
    adding, 15.6.6
    displaying information about, 15.14
    dropping, 15.6.8, 15.6.8.3
    increasing length, 15.6.5
    modifying definition, 15.6.5
    renaming, 15.6.7
  COMMENT statement, 15.14
  COMMIT COMMENT statement
    used with distributed transactions, 33.2, 33.4.3.2
  commit phase, 32.3.1, 32.5.4
    in two-phase commit, 32.3.2, 32.3.2.2
  commit point site, 32.2.5
    commit point strength, 32.2.5.2, 33.1
    determining, 32.2.5.2
    distributed transactions, 32.2.5, 32.2.5.2
    how the database determines, 32.2.5.2
  commit point strength
    definition, 32.2.5.2
    specifying, 33.1
  COMMIT statement
    FORCE clause, 33.5, 33.5.1.1, 33.5.2
    forcing, 33.4.2
    two-phase commit and, 29.4.6
  COMMIT_POINT_STRENGTH initialization parameter, 32.2.5.2, 33.1
  committing transactions
    commit point site for distributed transactions, 32.2.5
  composite partitioning
    default partition, 17.2.5
    range-hash, 17.2.4, 17.3.4
    range-list, 17.2.5, 17.3.5
    subpartition template, modifying, 17.4.11
  CONNECT command
    starting an instance, 3.1.3
  CONNECT INTERNAL
    desupported, 1.6.2
  connected user database links, 30.2.3.2
    advantages and disadvantages, 29.2.7.1
    definition, 29.2.7
    example, 29.2.8
    REMOTE_OS_AUTHENT initialization parameter, 29.2.7.1
  connection qualifiers
    database links and, 30.2.4
  connections
    terminating remote, 31.2
  constraints
    See also integrity constraints
    disabling at table creation, 13.5.2.1
    distributed system application development issues, 31.3
    dropping integrity constraints, 13.5.3.3
    enable novalidate state, 13.5.1.3
    enabling example, 13.5.2.2
    enabling when violations exist, 13.5.1.3
    exceptions, 13.5.1.2, 13.5.5
    exceptions to integrity constraints, 13.5.5
    integrity constraint states, 13.5.1
    keeping index when disabling, 13.5.3
    keeping index when dropping, 13.5.3
    ORA-02055 constraint violation, 31.3
    renaming, 13.5.3.2
    setting at table creation, 13.5.2
    when to disable, 13.5.1.1
  control file
    creating in Automatic Storage Management, 12.5.8
  control files
    adding, 5.3.2
    changing size, 5.3.1
    conflicts with data dictionary, 5.4.1
    creating, 5.1, 5.3, 5.3.3.2
    creating as Oracle-managed files, 11.3.5
    creating as Oracle-managed files, examples, 11.5.1
    default name, 2.4.3, 5.3.1
    dropping, 5.7
    errors during creation, 5.4.2
    guidelines for, 5.2
    importance of multiplexed, 5.2.2
    initial creation, 5.3.1
    location of, 5.2.2
    log sequence numbers, 6.1.3.2
    mirroring, 2.4.3, 5.2.2
    moving, 5.3.2
    multiplexed, 5.2.2
    names, 5.2.1
    number of, 5.2.2
    overwriting existing, 2.4.3
    relocating, 5.3.2
    renaming, 5.3.2
    requirement of one, 5.1
    size of, 5.2.4
    specifying names before database creation, 2.4.3
    troubleshooting, 5.4
    unavailable during startup, 3.1.4
  CONTROL_FILES initialization parameter
    overwriting existing control files, 2.4.3
    specifying file names, 5.2.1
    warning about setting, 2.4.3
    when creating a database, 2.4.3, 5.3.1
  copying jobs, 27.2.3
  coraenv and oraenv, 1.3
  corruption
    repairing data block, 21.1
  cost-based optimization, 31.4.2
    distributed databases, 29.5.3
    hints, 31.4.3
    using for distributed queries, 31.4.2
  CPU_COUNT initialization parameter, 24.9.2
  CREATE BIGFILE TABLESPACE statement, 8.2.2.1
  CREATE BIGFILE TEMPORARY TABLESPACE statement, 8.2.3.2
  CREATE CLUSTER statement
    creating clusters, 18.3
    example, 18.3
    for hash clusters, 19.3
    HASH IS clause, 19.3, 19.3.3.2
    HASHKEYS clause, 19.3, 19.3.3.4
    SIZE clause, 19.3.3.3
  CREATE CONTROLFILE statement
    about, 5.3.3.2
    checking for inconsistencies, 5.4.1
    creating as Oracle-managed files, examples, 11.3.5, 11.5.1
    NORESETLOGS clause, 5.3.3.3
    Oracle-managed files, using, 11.3.5
    RESETLOGS clause, 5.3.3.3
  CREATE DATABASE LINK statement, 30.2.2.1
  CREATE DATABASE statement
    CONTROLFILE REUSE clause, 5.3.1
    DEFAULT TEMPORARY TABLESPACE clause, 2.2.2.7, 2.3.6
    example of database creation, 2.2.2.7
    EXTENT MANAGEMENT LOCAL clause, 2.3.2
    MAXLOGFILES parameter, 6.2.4
    MAXLOGMEMBERS parameter, 6.2.4, 6.2.4
    password for SYS, 2.3.1
    password for SYSTEM, 2.3.1
    setting time zone, 2.3.9.1
    specifying FORCE LOGGING, 2.3.10
    SYSAUX DATAFILE clause, 2.2.2.7
    UNDO TABLESPACE clause, 2.2.2.7, 2.3.4
    used to create an undo tablespace, 10.4.1.1
    using Oracle-managed files, 11.3.2
    using Oracle-managed files, examples, 11.3.2.6, 11.5.1, 11.5.2
  CREATE INDEX statement
    NOLOGGING, 16.2.9
    ON CLUSTER clause, 18.3.2
    partitioned indexes, 17.3.1.2
    using, 16.3.1
    with a constraint, 16.3.3.1
  CREATE SCHEMA statement
    multiple tables and views, 13.1
  CREATE SEQUENCE statement, 20.2.2
    CACHE option, 20.2.4.2.2
    examples, 20.2.4.2.2
    NOCACHE option, 20.2.4.2.2
  CREATE SPFILE statement, 2.7.3
  CREATE SYNONYM statement, 20.3.2
  CREATE TABLE statement
    AS SELECT clause, 15.2.4, 15.3.3
    AS SELECT vs. direct-path INSERT, 15.4.2.1
    CLUSTER clause, 18.3.1
    COMPRESS clause, 15.12.2.7
    creating partitioned tables, 17.3.1
    creating temporary table, 15.3.2
    INCLUDING clause, 15.12.2.5
    index-organized tables, 15.12.2
    MONITORING clause, 15.5
    NOLOGGING clause, 15.2.5
    ORGANIZATION EXTERNAL clause, 15.13.1
    OVERFLOW clause, 15.12.2.3
    parallelizing, 15.3.3
    PCTTHRESHOLD clause, 15.12.2.4
    TABLESPACE clause, specifying, 15.2.3
    use of, 15.3.1
  CREATE TABLESPACE statement
    BLOCKSIZE CLAUSE, using, 8.3
    FORCE LOGGING clause, using, 8.4
    using Oracle-managed files, 11.3.3
    using Oracle-managed files, examples, 11.3.3.1
  CREATE TEMPORARY TABLESPACE statement, 8.2.3.1
    using Oracle-managed files, 11.3.4
    using Oracle-managed files, example, 11.3.4.1
  CREATE UNDO TABLESPACE statement
    using Oracle-managed files, 11.3.3
    using Oracle-Managed files, example, 11.3.3.2
    using to create an undo tablespace, 10.4.1.2
  CREATE UNIQUE INDEX statement
    using, 16.3.2
  CREATE VIEW statement
    about, 20.1.2
    OR REPLACE clause, 20.1.3
    WITH CHECK OPTION, 20.1.2, 20.1.4
  CREATE_SIMPLE_PLAN procedure
    Database Resource Manager, 24.3
  creating
    chains, 27.9.2
    control files, 5.3
    database using Automatic Storage Management, 12.5.5
    disk group, 12.4.2
    event schedule, 27.8.2.3
    event-based job, 27.8.2.1
    job classes, 27.5.2
    jobs, 27.2.2
    programs, 27.3.2
    Scheduler windows, 27.6.2
    schedules, 27.4.2
    sequences, 20.2.4.2.2, 20.2.4.2.2
    window groups, 27.7.2
  creating database links, 30.2
    connected user, 30.2.3.2.1
    connected user scenarios, 30.8.3
    current user, 30.2.3.2.2
    current user scenario, 30.8.5
    examples, 29.2.8
    fixed user, 30.2.3.1
    fixed user scenario, 30.8.1, 30.8.2
    obtaining necessary privileges, 30.2.1
    private, 30.2.2.1
    public, 30.2.2.2
    service names within link names, 30.2.4
    shared, 30.3
    shared connected user scenario, 30.8.4
    specifying types, 30.2.2
  creating databases, 2
    backing up the new database, 2.2.2.11
    default temporary tablespace, specifying, 2.3.6
    example, 2.2.2.7
    manually from a script, 2.1
    overriding default tablespace type, 2.3.8.2
    planning, 2.2.1
    preparing to, 2.2.1
    prerequisites for, 2.2.1.2
    problems encountered while, 2.5
    setting default tablespace type, 2.3.8.1
    specifying bigfile tablespaces, 2.3.8, 2.3.8.2
    UNDO TABLESPACE clause, 2.3.4
    upgrading to a new release, 2.1
    using Database Configuration Assistant, 2.1
    using Oracle-managed files, 2.3.7, 11.3.2
    with locally managed tablespaces, 2.3.2
  creating datafiles, 9.2
  creating indexes
    after inserting table data, 16.2.1
    associated with integrity constraints, 16.3.3
    NOLOGGING, 16.2.9
    USING INDEX clause, 16.3.3.1
  creating sequences, 20.2.2
  creating synonyms, 20.3.2
  creating views, 20.1.2
  current user database links
    advantages and disadvantages, 29.2.7.3
    cannot access in shared schema, 29.3.2.4.2
    definition, 29.2.7
    example, 29.2.8
    schema independence, 29.3.2.4.2
  CURRVAL pseudo-column, 20.2.4.1
    restrictions, 20.2.4.1.3
  cursors
    and closing database links, 31.2

## D

  data
    loading using external tables, 15.13.1
  data block corruption
    repairing, 21.1
  data blocks
    altering size of, 2.4.4.1
    managing space in, 14.2
    nonstandard block size, 2.4.4.2
    shared in clusters, 18.1
    specifying size of, 2.4.4
    standard block size, 2.4.4
    transaction entry settings, 14.2.1
    verifying, 9.7
  data dictionary
    conflicts with control files, 5.4.1
    purging pending rows from, 33.6, 33.6.2
    schema object views, 13.10, 14.7
  data encryption
    distributed systems, 29.3.2.5
  data manipulation language
    statements allowed in distributed transactions, 29.4.1
  database
    cloning, 1.2.11
    monitoring, 4.7
    starting up, 3.1
  database administrators
    DBA role, 1.5.2.3
    operating system account, 1.5.1
    password files for, 1.6.2.1
    responsibilities of, 1.1.1
    security and privileges of, 1.5
    security officer versus, 22.1
    SYS and SYSTEM accounts, 1.5.2
    task definitions, 1.2
    utilities for, 1.8.2
  Database Configuration Assistant
    shared server configuration, 4.2.3
  database links
    advantages, 29.2.3
    auditing, 29.3.3
    authentication, 29.3.2.1
    authentication without passwords, 29.3.2.2
    closing, 30.4.1, 31.2
    connected user, 29.2.7, 29.2.7.1, 30.2.3.2, 30.8.3
    connections, determining open, 30.5.2
    controlling connections, 31.2
    creating, 30.2, 30.8.1, 30.8.3, 30.8.4, 30.8.5
    creating shared, 30.3.2
    creating, examples, 29.2.8
    creating, scenarios, 30.8
    current user, 29.2.7, 29.2.7.3, 30.2.3.2
    data dictionary USER views, 30.5.1
    definition, 29.2.1
    distributed queries, 29.4.2
    distributed transactions, 29.4.5
    dropping, 30.4.2, 30.4.2
    enforcing global naming, 30.1.2
    enterprise users and, 29.3.2.4.2
    fixed user, 29.2.7, 29.2.7.2, 30.8.1
    global, 29.2.6
    global names, 29.2.4
    global object names, 29.4.7
    handling errors, 31.3
    limiting number of connections, 30.4.3
    listing, 30.5.1, 33.3.1, 33.3.2
    managing, 30.4
    minimizing network connections, 30.3
    name resolution, 29.4.7
    names for, 29.2.5
    private, 29.2.6
    public, 29.2.6
    referential integrity in, 31.3
    remote transactions, 29.4.1, 29.4.4
    resolution, 29.4.7
    restrictions, 29.2.10
    roles on remote database, 29.2.10
    schema objects and, 29.2.9
    service names used within link names, 30.2.4
    shared, 29.2.2, 30.3.1, 30.3.3, 30.3.3.1, 30.3.3.2
    shared SQL, 29.4.3
    synonyms for schema objects, 29.2.9.3
    tuning distributed queries, 31.4
    tuning queries with hints, 31.4.3
    tuning using collocated inline views, 31.4.1
    types of links, 29.2.6
    types of users, 29.2.7
    users, specifying, 30.2.3
    using cost-based optimization, 31.4.2
    viewing, 30.5, 30.5.1
  database objects
    obtaining growth trends for, 14.8.3
  Database Resource Manager
    active session pool with queuing, 24.1.4.4.2
    administering system privilege, 24.2
    and operating system control, 24.9
    automatic consumer group switching, 24.1.4.4.4
    CREATE_SIMPLE_PLAN procedure, 24.3
    description, 24.1
    enabling, 24.6
    execution time limit, 24.1.4.4.6
    multiple level CPU resource allocation, 24.1.4.4.1
    pending area, 24.4.1
    resource allocation methods, 24.1.3, 24.4.2, 24.4.2, 24.4.2, 24.4.2, 24.4.2, 24.4.2, 24.4.2, 24.4.3
    resource consumer groups, 24.1.3, 24.4.3, 24.5
    resource plan directives, 24.1.3, 24.4.1.2, 24.4.4
    resource plans, 24.1.3, 24.1.4.1, 24.1.4.2, 24.1.4.2, 24.1.4.2, 24.1.4.4.1, 24.3, 24.4.3, 24.6, 24.6, 24.7, 24.7.3, 24.10
    specifying a parallel degree limit, 24.1.4.4.3
    undo pool, 24.1.4.4.7
    used for quiescing a database, 3.4
    validating plan schema changes, 24.4.1.2
    views, 24.10
  database writer process
    calculating checksums for data blocks, 9.7
  database writer process (DBWn), 4.3
  DATABASE_PROPERTIES view
    name of default temporary tablespace, 2.3.6
    rename of default temporary tablespace, 8.7
  databases
    administering, 1
    administration of distributed, 30
    altering availability, 3.2
    backing up, 2.2.2.11
    control files of, 5.2
    creating manually, 2.2
    default temporary tablespace, specifying, 2.3.6
    dropping, 2.6
    global database names in distributed systems, 2.4.1.2
    mounting a database, 3.1.4.3
    mounting to an instance, 3.2.1
    names, about, 2.4.1.1
    names, conflicts in, 2.4.1.1
    opening a closed database, 3.2.2
    planning, 1.2.3
    planning creation, 2.2.1
    quiescing, 3.4
    read-only, opening, 3.2.3
    recovery, 3.1.4.6
    renaming, 5.3.3.1, 5.3.3.2, 5.3.3.3
    restricting access, 3.2.4
    resuming, 3.5
    shutting down, 3.3
    specifying control files, 2.4.3
    starting up, 3.1.2
    suspending, 3.5
    troubleshooting creation problems, 2.5
    undo management, 2.3.4
    upgrading, 2.1
    with locally managed tablespaces, 2.3.2
  datafile headers
    when renaming tablespaces, 8.7
  datafiles
    adding to a tablespace, 9.2
    bringing online and offline, 9.4
    checking associated tablespaces, 8.13.2
    copying using database, 9.8
    creating, 9.2
    creating Oracle-managed files, 11.3, 11.3.6.2
    database administrators access, 1.5.1
    default directory, 9.2
    definition, 9.1
    deleting, 8.8
    dropping, 9.4.2, 9.6
    dropping Oracle-managed files, 11.4.1
    file numbers, 9.1
    fully specifying filenames, 9.2
    guidelines for managing, 9.1
    headers when renaming tablespaces, 8.7
    identifying OS filenames, 9.5.1.2
    location, 9.1.3
    mapping files to physical devices, 9.9
    minimum number of, 9.1.1
    MISSING, 5.4.1
    monitoring using views, 9.10
    online, 9.4.2
    Oracle-managed, 11
    relocating, 9.5
    renaming, 9.5
    reusing, 9.2
    size of, 9.1.2
    statements to create, 9.2
    storing separately from redo log files, 9.1.4
    unavailable when database is opened, 3.1.4
    verifying data blocks, 9.7
  DB_BLOCK_CHECKING initialization parameter, 21.3.1, 21.3.1.4
  DB_BLOCK_CHECKSUM initialization parameter, 9.7
    enabling redo block checking with, 6.7
  DB_BLOCK_SIZE initialization parameter
    and nonstandard block sizes, 8.3
    setting, 2.4.4
  DB_CACHE_SIZE initialization parameter
    setting, 2.4.5.4.1
    specifying multiple block sizes, 8.3
  DB_DOMAIN initialization parameter
    setting for database creation, 2.4.1, 2.4.1.2
  DB_FILES initialization parameter
    determining value for, 9.1.1.1
  DB_NAME initialization parameter
    setting before database creation, 2.4.1
  DB_nK_CACHE_SIZE initialization parameter
    setting, 2.4.5.4.1
    specifying multiple block sizes, 8.3
    using with transportable tablespaces, 8.12.5.5
  DBA role, 1.5.2.3
  DBA. See database administrators.
  DBA_2PC_NEIGHBORS view, 33.3.2
    using to trace session tree, 33.3.2
  DBA_2PC_PENDING view, 33.3.1, 33.6, 33.7.6
    using to list in-doubt transactions, 33.3.1
  DBA_DB_LINKS view, 30.5.1, 30.5.1, 30.5.1
  DBA_RESUMABLE view, 14.4.4.1
  DBA_UNDO_EXTENTS view
    undo tablespace extents, 10.6
  DBCA. See Database Configuration Assistant
  DBMS_FILE_TRANSFER package
    copying datafiles, 9.7
  DBMS_METADATA package
    GET_DDL function, 13.10.1
    using for object definition, 13.10.1
  DBMS_REDEFINITION package
    performing online redefinition with, 15.7.2
    required privileges, 15.7.9
  DBMS_REPAIR
    logical corruptions, 21.3.2
  DBMS_REPAIR package
    examples, 21.4
    limitations, 21.2.2
    procedures, 21.2.1
    using, 21.3, 21.4.5
  DBMS_RESOURCE_MANAGER package, 24.1.4, 24.2, 24.5, 24.5.2
    procedures (table of), 24.2
  DBMS_RESOURCE_MANAGER_PRIVS package, 24.2, 24.5
    procedures (table of), 24.2
  DBMS_RESUMABLE package, 14.4.4.3
  DBMS_SERVER_ALERT package
    setting alert thresholds, 14.1
  DBMS_SESSION package, 24.5.2.3
  DBMS_SPACE package, 14.5.4
    example for unused space, 14.7.1
    FREE_BLOCK procedure, 14.7.1
    SPACE_USAGE procedure, 14.7.1
    UNUSED_SPACE procedure, 14.7.1
  DBMS_STATS package, 13.2.1
    MONITORING clause of CREATE TABLE, 15.5
  DBMS_STORAGE_MAP package
    invoking for file mapping, 9.9.3.1
    views detailing mapping information, 9.9.3.3
  DBMS_TRANSACTION package
    PURGE_LOST_DB_ENTRY procedure, 33.6.1
  DBVERIFY utility, 21.3.1, 21.3.1.2
  DEALLOCATE UNUSED clause, 14.5.4
  deallocating unused space, 14.5
    DBMS_SPACE package, 14.5.4
    DEALLOCATE UNUSED clause, 14.5.4
  declarative referential integrity constraints, 31.3
  dedicated server processes, 4.1.1
    trace files for, 4.7.2
  DEFAULT keyword
    list partitioning, 17.3.3
  default partitions, 17.2.3
  default subpartition, 17.2.5
  default temporary tablespace
    renaming, 8.7
  default temporary tablespaces
    specifying at database creation, 2.2.2.7, 2.3.6
    specifying bigfile tempfile, 2.3.8.2
  DEFAULT_CONSUMER_GROUP for Database Resource Manager, 24.4.3, 24.4.3.3, 24.5.3.2
  defining
    chain steps, 27.9.3
  dependencies
    displaying, 13.10.2.2
  dictionary-managed tablespaces
    migrating SYSTEM to locally managed, 8.11
  Digital POLYCENTER Manager on NetView, 29.3.4.3
  directories
    managing disk group, 12.4.7
  direct-path INSERT
    benefits, 15.4.2.1
    how it works, 15.4.2.3
    index maintenance, 15.4.2.5.1
    locking considerations, 15.4.2.5.3
    logging mode, 15.4.2.4
    parallel INSERT, 15.4.2.2
    parallel load compared with parallel INSERT, 15.4.2.1, 15.4.2.1
    serial INSERT, 15.4.2.2
    space considerations, 15.4.2.5.2
  DISABLE ROW MOVEMENT clause, 17.3
  disabling
    chains, 27.9.10
    jobs, 27.2.8
    programs, 27.3.5
    window groups, 27.7.7
    windows, 27.6.7
  disabling recoverer process, 33.9.2
  disk discovery
    in Automatic Storage Management, 12.2, 12.3.4.3
  disk failure
    in Automatic Storage Management, 12.4.1.4
  disk group
    adding templates to, 12.4.10.1
    altering membership of, 12.4.3
    creating, 12.4.2
    dropping, 12.4.6
    dropping disks from, 12.4.3.2
    managing capacity in, 12.4.1.6
    manually rebalancing, 12.4.3.5
    mounting and dismounting, 12.4.4
    resizing disks in, 12.4.3.3
    undropping disks in, 12.4.3.4
  disk groups, administering, 12.4
  dispatcher process (Dnnn), 4.3
  dispatcher processes, 4.2.3.3, 4.2.4
  DISPATCHERS initialization parameter
    setting attributes of, 4.2.3.1
    setting initially, 4.2.3.3
  distributed applications
    distributing data, 31.1
  distributed databases
    administration overview, 29.3
    application development, 29.5, 31, 31.5
    client/server architectures, 29.1.3
    commit point strength, 32.2.5.2
    cost-based optimization, 29.5.3
    direct and indirect connections, 29.1.3
    distributed processing, 29.1.1.1
    distributed queries, 29.4.2
    distributed updates, 29.4.2, 29.4.2
    forming global database names, 30.1.1
    global object names, 29.2.9.4, 30.1
    globalization support, 29.6
    location transparency, 29.5.1.1, 30.6
    management tools, 29.3.4
    managing read consistency, 33.10
    nodes of, 29.1.3
    overview, 29.1.1
    remote object security, 30.6.1
    remote queries and updates, 29.4.1
    replicated databases and, 29.1.1.2
    resumable space allocation, 14.4.1.4
    running in ARCHIVELOG mode, 7.2.2
    running in NOARCHIVELOG mode, 7.2.2
    scenarios, 30.8
    schema object name resolution, 29.4.8
    schema-dependent global users, 29.3.2.4.1
    schema-independent global users, 29.3.2.4.2
    security, 29.3.2
    site autonomy of, 29.3.1
    SQL transparency, 29.5.1.2
    starting a remote instance, 3.1.4.8
    transaction processing, 29.4
    transparency, 29.5.1
  distributed processing
    distributed databases, 29.1.1.1
  distributed queries, 29.4.2
    analyzing tables, 31.4.2.2.2
    application development issues, 31.4
    cost-based optimization, 31.4.2
    optimizing, 29.5.3
  distributed systems
    data encryption, 29.3.2.5
  distributed transactions, 29.4.5
    case study, 32.5
    commit point site, 32.2.5
    commit point strength, 32.2.5.2, 33.1
    committing, 32.2.5.1
    database server role, 32.2.2
    defined, 32.1
    DML and DDL, 32.1.1
    failure during, 33.8.1
    global coordinator, 32.2.4
    local coordinator, 32.2.3
    lock timeout interval, 33.8
    locked resources, 33.8
    locks for in-doubt, 33.8.2
    manually overriding in-doubt, 33.4.2
    naming, 33.2, 33.4.3.2
    session trees, 32.2, 32.2.2, 32.2.3, 32.2.4, 32.2.5, 33.3.2
    setting advice, 33.4.3.3
    transaction control statements, 32.1.2
    transaction timeouts, 33.8.1
    two-phase commit, 32.5, 33.4.1
    viewing database links, 33.3.1
  distributed updates, 29.4.2
  DML error logging, inserting data with, 15.4.1
  DML. See data manipulation language
  DRIVING_SITE hint, 31.4.3.2
  DROP CLUSTER statement
    CASCADE CONSTRAINTS clause, 18.5
    dropping cluster, 18.5
    dropping cluster index, 18.5
    dropping hash cluster, 19.5
    INCLUDING TABLES clause, 18.5
  DROP DATABASE statement, 2.6
  DROP LOGFILE clause
    ALTER DATABASE statement, 6.5.1
  DROP LOGFILE MEMBER clause
    ALTER DATABASE statement, 6.5.2
  DROP PARTITION clause, 17.4.4.1
  DROP SYNONYM statement, 20.3.4
  DROP TABLE statement
    about, 15.10
    CASCADE CONSTRAINTS clause, 15.10
    for clustered tables, 18.5.1
  DROP TABLESPACE statement, 8.8
  dropping
    aliases from a disk group, 12.4.9
    Automatic Storage Management template, 12.4.10.3
    chain steps, 27.9.11
    chains, 27.9.7
    datafiles, 9.6
    disk groups, 12.4.6
    disks from a disk group, 12.4.3.2
    files from a disk group, 12.4.9
    job classes, 27.5.4
    jobs, 27.2.7, 28.2.8
    programs, 27.3.4
    rules from chains, 27.9.9
    running jobs, 28.2.9
    schedules, 27.4.4
    tempfiles, 9.6
    window groups, 27.7.3
    windows, 27.6.6
  dropping columns from tables, 15.6.8.1
    marking unused, 15.6.8.2
    remove unused columns, 15.6.8.2
  dropping database links, 30.4.2, 30.4.2
  dropping datafiles
    Oracle-managed, 11.4.1
  dropping partitioned tables, 17.5
  dropping tables
    CASCADE clause, 15.10
    consequences of, 15.10
  dropping tempfiles
    Oracle-managed, 11.4.1
  DUMP_ORPHAN_KEYS procedure, 21.3.2
    checking sync, 21.3.2
    DBMS_REPAIR package, 21.2.1
    example, 21.4.4
    recovering data, 21.3.4.1

## E

  EMPHASIS resource allocation method, 24.4.2
  ENABLE ROW MOVEMENT clause, 17.3, 17.3.1.1
  enabling
    chains, 27.9.5
    jobs, 27.2.9
    programs, 27.3.6
    window groups, 27.7.6
    windows, 27.6.8
  enabling recoverer process
    distributed transactions, 33.9.2
  encryption, transparent data, 2.9.2
  enterprise users
    definition, 29.3.2.4.2
  environment variables
    selecting an instance with, 1.3
  error logging, DML
    inserting data with, 15.4.1
  errors
    alert log and, 4.7.2
    assigning names with PRAGMA_EXCEPTION_INIT, 31.5
    exception handler, 31.5
    integrity constrain violation, 31.3
    ORA-00028, 4.6.2
    ORA-01090, 3.3
    ORA-01173, 5.4.2
    ORA-01176, 5.4.2
    ORA-01177, 5.4.2
    ORA-01578, 9.7
    ORA-01591, 33.8.2
    ORA-02049, 33.8.1
    ORA-02050, 33.4.1
    ORA-02051, 33.4.1
    ORA-02054, 33.4.1
    ORA-1215, 5.4.2
    ORA-1216, 5.4.2
    RAISE_APPLICATION_ERROR() procedure, 31.5
    remote procedure, 31.5
    rollback required, 31.3
    trace files and, 4.7.2
    when creating a database, 2.5
    when creating control file, 5.4.2
    while starting a database, 3.1.4.5
    while starting an instance, 3.1.4.5
  event message
    passing to event-based job, 27.8.2.5
  event schedule
    altering, 27.8.2.4
    creating, 27.8.2.3
  event-based job
    altering, 27.8.2.2
    creating, 27.8.2.1
    passing event messages to, 27.8.2.5
  events (Scheduler)
    overview, 26.2.4
    using, 27.8
  exception handler, 31.5
  EXCEPTION keyword, 31.5
  exceptions
    assigning names with PRAGMA_EXCEPTION_INIT, 31.5
    integrity constraints, 13.5.5
    user-defined, 31.5
  EXCHANGE PARTITION clause, 17.4.5.1, 17.4.5.3, 17.4.5.4, 17.4.5.5, 17.4.6
  execution plans
    analyzing for distributed queries, 31.4.4
  export operations
    restricted mode and, 3.1.4.4
  export utilities
    about, 1.8.2.2
  expressions, calendaring, 27.4.5.1
  EXTENT MANAGEMENT LOCAL clause
    CREATE DATABASE, 2.3.2
  extents
    allocating cluster extents, 18.4
    allocating for tables, 15.6.4
    data dictionary views for, 14.7.2
    deallocating cluster extents, 18.4
    displaying free extents, 14.7.2.3
  external jobs
    running, 27.2.5.4
  external procedures
    managing processes for, 4.5
  external tables
    altering, 15.13.2
    creating, 15.13.1
    defined, 15.13
    dropping, 15.13.3
    privileges required, 15.13.4
    uploading data example, 15.13.1

## F

  failure groups, 12.2, 12.4.1.5
  features
    new, Preface
  file mapping
    examples, 9.9.4
    how it works, 9.9.2
    how to use, 9.9.3
    overview, 9.9.1
    structures, 9.9.2.2
    views, 9.9.3.3
  file system
    used for Oracle-managed files, 11.1.1.2
  FILE_MAPPING initialization parameter, 9.9.3.1
  filenames
    Automatic Storage Management, 12.5.2
    Oracle-managed files, 11.3.1
  files
    creating Oracle-managed files, 11.3, 11.3.6.2
  FIX_CORRUPT_BLOCKS procedure
    DBMS_REPAIR, 21.2.1
    example, 21.4.3
    marking blocks corrupt, 21.3.3.1
  fixed user database links
    advantages and disadvantages, 29.2.7.2
    creating, 30.2.3.1
    definition, 29.2.7
    example, 29.2.8
  flash recovery area
    initialization parameters to specify, 2.4.2
  Flashback Drop
    about, 15.11
    purging recycle bin, 15.11.4
    querying recycle bin, 15.11.3
    recycle bin, 15.11.1
    restoring objects, 15.11.5
  Flashback Table
    overview, 15.9
  Flashback Transaction Query, 15.8
  FMON background process, 9.9.2.1.1
  FMPUTL external process
    used for file mapping, 9.9.2.1.2
  FOR PARTITION clause, 17.4.8.1
  FORCE clause
    COMMIT statement, 33.5
    ROLLBACK statement, 33.5
  FORCE LOGGING clause
    CREATE CONTROLFILE, 2.3.10.1
    CREATE DATABASE, 2.3.10
    CREATE TABLESPACE, 8.4
    performance considerations, 2.3.10.2
  FORCE LOGGING mode, 15.4.2.4
  forcing
    COMMIT or ROLLBACK, 33.3.1, 33.4.2
  forcing a log switch, 6.6
    using ARCHIVE_LAG_TARGET, 6.2.5
    with the ALTER SYSTEM statement, 6.6
  forget phase
    in two-phase commit, 32.3.3
  free space
    listing free extents, 14.7.2.3
    tablespaces and, 8.13.3
  function-based indexes, 16.3.7
  functions
    recompiling, 13.7.2

## G

  generic connectivity
    definition, 29.1.2.3
  global cache service (LMS), 4.3
  global coordinators, 32.2.4
    distributed transactions, 32.2.4
  global database consistency
    distributed databases and, 32.3.2.2
  global database links, 29.2.6
    creating, 30.2.2.3
  global database names
    changing the domain, 30.1.4
    database links, 29.2.4
    enforcing for database links, 29.2.5
    enforcing global naming, 30.1.2
    forming distributed database names, 30.1.1
    impact of changing, 29.4.9.1
    querying, 30.1.3
  global object names
    database links, 29.4.7
    distributed databases, 30.1
  global users, 30.8.5
    schema-dependent in distributed systems, 29.3.2.4.1
    schema-independent in distributed systems, 29.3.2.4.2
  GLOBAL_NAME view
    using to determine global database name, 30.1.3
  GLOBAL_NAMES initialization parameter
    database links, 29.2.5
  globalization support
    client/server architectures, 29.6.1
    distributed databases, 29.6
  GRANT statement
    SYSOPER/SYSDBA privileges, 1.7.3.1
  granting privileges and roles
    SYSOPER/SYSDBA privileges, 1.7.3.1
  growth trends
    of database objects, 14.8.3
  GV$DBLINK view, 30.5.2

## H

  hash clusters
    advantages and disadvantages, 19.1
    altering, 19.4
    choosing key, 19.3.3.1
    contrasted with index clusters, 19.1
    controlling space use of, 19.3.3
    creating, 19.3
    dropping, 19.5
    estimating storage, 19.3.4
    examples, 19.3.3.5.1
    hash function, 19.1, 19.2.2, 19.3, 19.3.3.1, 19.3.3.2, 19.3.3.3
    HASH IS clause, 19.3, 19.3.3.2
    HASHKEYS clause, 19.3, 19.3.3.4
    single-table, 19.3.2
    SIZE clause, 19.3.3.3
    sorted, 19.3.1
  hash functions
    for hash cluster, 19.1
  hash partitioning
    creating tables using, 17.3.2
    index-organized tables, 17.3.10.2, 17.3.10.3
    multicolumn partitioning keys, 17.3.7
  heterogeneous distributed systems
    definition, 29.1.2
  Heterogeneous Services
    overview, 29.1.2
  hints, 31.4.3
    DRIVING_SITE, 31.4.3.2
    NO_MERGE, 31.4.3.1
    using to tune distributed queries, 31.4.3
  historical tables
    moving time window, 17.6
  HP OpenView, 29.3.4.3

## I

  IBM NetView/6000, 29.3.4.3
  import operations
    restricted mode and, 3.1.4.4
  import utilities
    about, 1.8.2.2
  index clusters. See clusters.
  indexes
    altering, 16.4
    analyzing, 13.2
    choosing columns to index, 16.2.2
    cluster indexes, 18.3.2, 18.4.1, 18.5
    coalescing, 16.2.10, 16.4.2
    column order for performance, 16.2.3
    creating, 16.3
    disabling and dropping constraints cost, 16.2.11
    dropping, 16.2.5, 16.6, 16.6
    estimating size, 16.2.6
    estimating space use, 14.8.2
    explicitly creating a unique index, 16.3.2
    function-based, 16.3.7
    guidelines for managing, 16.1
    keeping when disabling constraint, 13.5.3
    keeping when dropping constraint, 13.5.3
    key compression, 16.3.8
    limiting for a table, 16.2.4
    monitoring space use of, 16.5
    monitoring usage, 16.4.3
    parallelizing index creation, 16.2.8
    partitioned, 17.1
    rebuilding, 16.2.10, 16.4.2, 16.4.2
    rebuilt after direct-path INSERT, 15.4.2.5.1
    setting storage parameters for, 16.2.6
    shrinking, 14.5.3
    space used by, 16.5
    statement for creating, 16.3.1
    tablespace for, 16.2.7
    temporary segments and, 16.2.1
    updating global indexes, 17.4.1
    validating structure, 13.2.2
    when to create, 16.2.2
  index-organized tables
    analyzing, 15.12.5
    AS subquery, 15.12.2.6
    converting to heap, 15.12.7
    creating, 15.12.2
    described, 15.12.1
    INCLUDING clause, 15.12.2.5
    key compression, 15.12.2.7
    maintaining, 15.12.3
    ORDER BY clause, using, 15.12.6
    overflow clause, 15.12.2.3
    parallel creation, 15.12.2.6
    partitioning, 17.3, 17.3.10
    partitioning secondary indexes, 17.3.10.1
    rebuilding with MOVE clause, 15.12.3.2
    storing nested tables, 15.12.2.2
    storing object types, 15.12.2.2
    threshold value, 15.12.2.4
  in-doubt transactions, 32.4
    after a system failure, 33.4.1
    automatic resolution, 32.4.1, 32.4.1.1
    deciding how to handle, 33.4
    deciding whether to perform manual override, 33.4.2
    defined, 32.3.1.2
    manual resolution, 32.4.2
    manually committing, 33.5.1
    manually committing, example, 33.7
    manually overriding, 33.4.2, 33.5
    manually overriding, scenario, 33.7
    manually rolling back, 33.5.2
    overview, 32.4
    pending transactions table, 33.7.6
    purging rows from data dictionary, 33.6, 33.6.2
    recoverer process and, 33.9.2
    rolling back, 33.5, 33.5.1.1, 33.5.2, 33.5.2
    SCNs and, 32.4.3
    simulating, 33.9
    tracing session tree, 33.3.2
    viewing database links, 33.3.1
  INITIAL parameter
    cannot alter, 14.3.7, 15.6.2
    description, 14.3.1
  initialization parameter file
    and Automatic Storage Management, 3.1.2
    creating, 2.2.2.3
    creating for database creation, 2.2.2.3
    editing before database creation, 2.4
    individual parameter names, 2.4.1
    server parameter file, 2.7
    understanding, 3.1.2
  initialization parameters
    ARCHIVE_LAG_TARGET, 6.2.5.1
    BACKGROUND_DUMP_DEST, 4.7.2.2
    COMMIT_POINT_STRENGTH, 32.2.5.2, 33.1
    CONTROL_FILES, 2.4.3, 2.4.3, 2.4.3, 5.2.1, 5.3.1
    DB_BLOCK_CHECKING, 21.3.1.4
    DB_BLOCK_CHECKSUM, 6.7, 9.7
    DB_BLOCK_SIZE, 2.4.4, 8.3
    DB_CACHE_SIZE, 2.4.5.4.1, 8.3
    DB_DOMA, 2.4.1
    DB_DOMAIN, 2.4.1.2
    DB_FILES, 9.1.1.1
    DB_NAME, 2.4.1
    DB_nK_CACHE_SIZE, 2.4.5.4.1, 8.3, 8.12.5.5
    DISPATCHERS, 4.2.3.3
    FILE_MAPPING, 9.9.3.1
    for Automatic Storage Management, 12.3.3
    for Automatic Storage Management instance, 12.3.3.1
    for buffer cache, 2.4.5.4.1
    GLOBAL_NAMES, 29.2.5
    LOG_ARCHIVE_DEST, 7.4.1
    LOG_ARCHIVE_DEST_n, 7.4.1, 7.6.2
    LOG_ARCHIVE_DEST_STATE_n, 7.4.2
    LOG_ARCHIVE_MAX_PROCESSES, 7.3.4
    LOG_ARCHIVE_MIN_SUCCEED_DEST, 7.6.1
    LOG_ARCHIVE_TRACE, 7.7
    MAX_DUMP_FILE_SIZE, 4.7.2.3
    OPEN_LINKS, 30.4.3
    PROCESSES, 2.4.6
    REMOTE_LOGIN_PASSWORDFILE, 1.7.2
    REMOTE_OS_AUTHENT, 29.2.7.1
    RESOURCE_MANAGER_PLAN, 24.6, 24.6
    server parameter file and, 2.7, 2.7.9
    SET SQL_TRACE, 4.7.2.4
    SGA_MAX_SIZE, 2.4.5
    shared server and, 4.2.1
    SHARED_SERVERS, 4.2.2.2
    SORT_AREA_SIZE, 16.2.1
    SPFILE, 2.7.4, 3.1.2
    SQL_TRACE, 4.7.2
    STATISTICS_LEVEL, 15.5
    UNDO_MANAGEMENT, 2.3.4, 10.2.1
    UNDO_TABLESPACE, 2.4.7.2, 10.2.1
    USER_DUMP_DEST, 4.7.2.2
  INITRANS parameter
    altering, 15.6.2
    guidelines for setting, 14.2.1
  INSERT statement
    with DML error logging, 15.4.1
  installing
    patches, 1.2.10
  installing Automatic Storage Management, 12.3.1
  instance
    selecting with environment variables, 1.3
  INSTANCE_TYPE, 12.3.3.1
  instances
    aborting, 3.3.4
    shutting down immediately, 3.3.2
    shutting down normally, 3.3.1
    transactional shutdown, 3.3.3
  integrity constraints
    See also constraints
    cost of disabling, 16.2.11
    cost of dropping, 16.2.11
    creating indexes associated with, 16.3.3
    dropping tablespaces and, 8.8
    ORA-02055 constraint violation, 31.3
  INTERNAL username
    connecting for shutdown, 3.3
  IOT. See index-organized tables.

## J

  job classes
    altering, 27.5.3
    creating, 27.5.2
    dropping, 27.5.4
    overview, 26.3.1
    using, 27.5
  job coordinator, 26.4.2, 28.2.5
  job recovery (Scheduler), 28.2.11
  jobs
    altering, 27.2.4
    copying, 27.2.3
    creating, 27.2.2
    creating for chains, 27.9.6
    disabling, 27.2.8
    dropping, 27.2.7, 28.2.8
    dropping running, 28.2.9
    enabling, 27.2.9
    overview, 26.2.3
    priorities, 28.2.12
    running, 27.2.5
    stopping, 27.2.6
    using, 27.2
    viewing information on running, 28.2.4
  join views
    definition, 20.1.2.1
    DELETE statements, 20.1.5.2.2
    key-preserved tables in, 20.1.5.1
    modifying, 20.1.5
    rules for modifying, 20.1.5.2
    updating, 20.1.5
  joins
    statement transparency in distributed databases, 30.7

## K

  key compression, 15.12.2.7
    indexes, 16.3.8
  key-preserved tables
    in join views, 20.1.5.1
    in outer joins, 20.1.5.3
  keys
    cluster, 18.1, 18.2.3

## L

  LIST CHAINED ROWS clause
    of ANALYZE statement, 13.2.3.1
  list partitioning
    adding values to value list, 17.4.9
    creating tables using, 17.3.3
    DEFAULT keyword, 17.3.3
    dropping values from value-list, 17.4.10
    when to use, 17.2.3
  listing database links, 30.5.1, 33.3.1, 33.3.2
  loading data
    using external tables, 15.13.1
  LOBs
    storage parameters for, 14.3.6
  local coordinators, 32.2.3
    distributed transactions, 32.2.3
  locally managed tablespaces, 8.2.1
    automatic segment space management in, 8.2.1.2
    DBMS_SPACE_ADMIN package, 8.10
    detecting and repairing defects, 8.10
    migrating SYSTEM from dictionary-managed, 8.11
    tempfiles, 8.2.3.1
    temporary, creating, 8.2.3.1
  location transparency in distributed databases
    creating using synonyms, 30.6.2
    creating using views, 30.6.1
    restrictions, 30.7
    using procedures, 30.6.3.3
  lock timeout interval
    distributed transactions, 33.8
  locks
    in-doubt distributed transactions, 33.8, 33.8.2
    monitoring, 4.7.3
  log
    window (Scheduler), 27.6
  log sequence number
    control files, 6.1.3.2
  log switches
    description, 6.1.3.2
    forcing, 6.6, 6.6
    log sequence numbers, 6.1.3.2
    multiplexed redo log files and, 6.2.1.1
    privileges, 6.6
    using ARCHIVE_LAG_TARGET, 6.2.5
    waiting for archiving to complete, 6.2.1.1
  log writer process (LGWR), 4.3
    multiplexed redo log files and, 6.2.1.1
    online redo logs available for use, 6.1.3
    trace file monitoring, 4.7.2.1
    trace files and, 6.2.1.1
    writing to online redo log files, 6.1.3
  LOG_ARCHIVE_DEST initialization parameter
    specifying destinations using, 7.4.1
  LOG_ARCHIVE_DEST_n initialization parameter, 7.4.1
    REOPEN attribute, 7.6.2
  LOG_ARCHIVE_DEST_STATE_n initialization parameter, 7.4.2
  LOG_ARCHIVE_DUPLEX_DEST initialization parameter
    specifying destinations using, 7.4.1
  LOG_ARCHIVE_MAX_PROCESSES initialization parameter, 7.3.4
  LOG_ARCHIVE_MIN_SUCCEED_DEST initialization parameter, 7.6.1
  LOG_ARCHIVE_TRACE initialization parameter, 7.7
  LOGGING clause
    CREATE TABLESPACE, 8.4
  logging mode
    direct-path INSERT, 15.4.2.4
    NOARCHIVELOG mode and, 15.4.2.4.1
  logical corruptions from DBMS_REPAIR, 21.3.2
  logical volume managers
    mapping files to physical devices, 9.9, 9.9.4.3
    used for Oracle-managed files, 11.1.1.1
  LOGON trigger
    setting resumable mode, 14.4.3
  logs
    job, 28.2.6
    window (Scheduler), 27.6, 28.2.6
  LONG columns, 30.7
  LONG RAW columns, 30.7
  LOW_GROUP for Database Resource Manager, 24.4.3, 24.7.3

## M

  maintenance windows
    Scheduler, 23.1
  managing
    Automatic Storage Management templates, 12.4.10
    undo tablespace, 10
  managing capacity in disk groups, 12.4.1.6
  managing datafiles, 9
  managing sequences, 20.2.1
  managing synonyms, 20.3.1
  managing tables, 15
  managing views, 20.1
  manual archiving
    in ARCHIVELOG mode, 7.3.3
  manual overrides
    in-doubt transactions, 33.5
  MAX_DUMP_FILE_SIZE initialization parameter, 4.7.2.3
  MAXDATAFILES parameter
    changing, 5.3.3.2
  MAXINSTANCES, 5.3.3.2
  MAXLOGFILES parameter
    changing, 5.3.3.2
    CREATE DATABASE statement, 6.2.4
  MAXLOGHISTORY parameter
    changing, 5.3.3.2
  MAXLOGMEMBERS parameter
    changing, 5.3.3.2
    CREATE DATABASE statement, 6.2.4, 6.2.4
  MAXTRANS parameter
    altering, 15.6.2
  media recovery
    effects of archiving on, 7.2.1
  migrated rows
    eliminating from table, procedure, 13.2.3.2
  migrating a database to Automatic Storage Management, 12.6
  MINEXTENTS parameter
    cannot alter, 14.3.7, 15.6.2
    description, 14.3.1
  mirrored files
    control files, 2.4.3, 5.2.2
    online redo log, 6.2.1.1
    online redo log location, 6.2.2
    online redo log size, 6.2.3
  MISSING datafiles, 5.4.1
  MODIFY DEFAULT ATTRIBUTES clause, 17.4.8.1
    using for partitioned tables, 17.4.7.1
  MODIFY DEFAULT ATTRIBUTES FOR PARTITION clause
    of ALTER TABLE, 17.4.7.2, 17.4.7.3
  MODIFY PARTITION clause, 17.4.8.1, 17.4.8.2, 17.4.12, 17.4.14.2.2
  MODIFY SUBPARTITION clause, 17.4.8.3
  monitoring
    chains, 28.2.13
  MONITORING clause
    CREATE TABLE, 15.5
  monitoring datafiles, 9.10
  MONITORING USAGE clause
    of ALTER INDEX statement, 16.4.3
  mounting a database, 3.1.4.3
  mounting and dismounting disk groups, 12.4.4
  MOVE PARTITION clause, 17.4.8, 17.4.12
  MOVE SUBPARTITION clause, 17.4.8, 17.4.12.2
  moving control files, 5.3.2
  multiple temporary tablespaces, 8.2.4, 8.2.4.3
  multiplexed control files
    importance of, 5.2.2
  multiplexing
    archived redo logs, 7.4.1
    control files, 5.2.2
    redo log file groups, 6.2.1
    redo log files, 6.2.1, 6.2.1

## N

  name resolution in distributed databases
    database links, 29.4.7
    impact of global name changes, 29.4.9.1
    procedures, 29.4.9
    schema objects, 29.2.9.4, 29.4.8
    synonyms, 29.4.9
    views, 29.4.9
    when global database name is complete, 29.4.7.1
    when global database name is partial, 29.4.7.2
    when no global database name is specified, 29.4.7.3
  named user limits
    setting initially, 2.4.9
  nested tables
    storage parameters for, 14.3.6
  networks
    connections, minimizing, 30.3
    distributed databases use of, 29.1.1
  NEXT parameter
    altering, 14.3.7, 15.6.2
  NEXTVAL pseudo-column, 20.2.4.1, 20.2.4.1.1
    restrictions, 20.2.4.1.3
  NO_DATA_FOUND keyword, 31.5
  NO_MERGE hint, 31.4.3.1
  NOARCHIVELOG mode
    archiving, 7.2
    definition, 7.2.1
    dropping datafiles, 9.4.2
    LOGGING mode and, 15.4.2.4.1
    media failure, 7.2.1
    no hot backups, 7.2.1
    running in, 7.2.1
    switching to, 7.3.2
    taking datafiles offline in, 9.4.2
  NOCACHE option
    CREATE SEQUENCE statement, 20.2.4.2.2
  NOLOGGING clause
    CREATE TABLESPACE, 8.4
  NOLOGGING mode
    direct-path INSERT, 15.4.2.4
  NOMOUNT clause
    STARTUP command, 3.1.4.2
  normal transmission mode
    definition, 7.5.1
  Novell NetWare Management System, 29.3.4.3
  NOWAIT keyword
    in REBALANCE clause, 12.4.3

## O

  object privileges
    for external tables, 15.13.4
  objects
    See also schema objects
  offline tablespaces
    priorities, 8.5.1
    taking offline, 8.5.1
  online redefinition of tables, 15.7
    abort and cleanup, 15.7.5
    examples, 15.7.8
    features of, 15.7.1
    intermediate synchronization, 15.7.4
    redefining a single partition, 15.7.7
      rules for, 15.7.7.1
    restrictions, 15.7.6
    with DBMS_REDEFINITION, 15.7.2
  online redo log files
    See also online redo logs
  online redo logs
    See also redo log files
    creating groups, 6.3
    creating members, 6.3.2
    dropping groups, 6.5
    dropping members, 6.5
    forcing a log switch, 6.6
    guidelines for configuring, 6.2
    INVALID members, 6.5.2
    location of, 6.2.2
    managing, 6
    moving files, 6.4
    number of files in the, 6.2.4
    optimum configuration for the, 6.2.4
    renaming files, 6.4
    renaming members, 6.4
    specifying ARCHIVE_LAG_TARGET, 6.2.5
    STALE members, 6.5.2
    viewing information about, 6.9
  online segment shrink, 14.5.3
  OPEN_LINKS initialization parameter, 30.4.3
  opening windows, 27.6.4
  operating system authentication, 1.6.3.2
    for Automatic Storage Management, 12.3.2.1
  operating systems
    database administrators requirements for, 1.5.1
    renaming and relocating files, 9.5
  ORA_TZFILE environment variable
    specifying time zone file for database, 2.3.9.2
  ORA-02055 error
    integrity constraint violation, 31.3
  ORA-02067 error
    rollback required, 31.3
  Oracle Call Interface. See OCI
  Oracle Database
    release numbers, 1.4.1
  Oracle Database users
    types of, 1.1
  Oracle Enterprise Manager, 3.1.1.3, 3.1.1.3
  Oracle home
    cloning, 1.2.11
  Oracle Managed Files feature
    See also Oracle-managed files
  Oracle Net
    service names in, 7.5.2
    transmitting archived logs via, 7.5.2
  Oracle Universal Installer, 2.1
  Oracle-managed files
    adding to an existing database, 11.5.3
    behavior, 11.4
    benefits, 11.1.2
    CREATE DATABASE statement, 11.3.2
    creating, 11.3
    creating control files, 11.3.5
    creating datafiles, 11.3.3
    creating online redo log files, 11.3.6
    creating tempfiles, 11.3.4
    described, 11.1
    dropping datafile, 11.4.1
    dropping online redo log files, 11.4.2
    dropping tempfile, 11.4.1
    initialization parameters, 11.2
    introduction, 2.3.7
    naming, 11.3.1
    renaming, 11.4.3
    scenarios for using, 11.5
  Oracle-managed files feature
    See also Oracle-managed files
  oraenv and coraenv, 1.3
  ORAPWD utility, 1.7.1
  ORGANIZATION EXTERNAL clause
    of CREATE TABLE, 15.13.1
  orphan key table
    example of building, 21.4.1.2
  OSDBA group, 1.6.3.1
  OSOPER group, 1.6.3.1
  OTHER_GROUPS for Database Resource Manager, 24.1.4.2, 24.4.1.2, 24.4.3, 24.4.4.1, 24.7.3
  outer joins, 20.1.5.3
    key-preserved tables in, 20.1.5.3
  overlapping windows, 27.6.9

## P

  packages
    DBMS_FILE_TRANSFER, 9.7
    DBMS_METADATA, 13.10.1
    DBMS_REDEFINITION, 15.7.2, 15.7.9
    DBMS_REPAIR, 21.2
    DBMS_RESOURCE_MANAGER, 24.1.4, 24.2, 24.2, 24.5, 24.5.2
    DBMS_RESOURCE_MANAGER_PRIVS, 24.2, 24.2, 24.5
    DBMS_RESUMABLE, 14.4.4.3
    DBMS_SESSION, 24.5.2.3
    DBMS_SPACE, 14.5.4, 14.7.1
    DBMS_STATS, 13.2.1, 15.5
    DBMS_STORAGE_MAP, 9.9.3.2, 9.9.3.3
    privileges for recompiling, 13.7.3
    recompiling, 13.7.3
  parallel execution
    managing, 4.4
    parallel hints, 4.4, 4.4
    parallelizing index creation, 16.2.8
    resumable space allocation, 14.4.1.5
  parallel hints, 4.4, 4.4
  PARALLEL_DEGREE_LIMIT_ABSOLUTE resource allocation method, 24.4.2
  parallelizing table creation, 15.2.4, 15.3.3
  parameter files
    See also initialization parameter file.
  PARTITION BY HASH clause, 17.3.2
  PARTITION BY LIST clause, 17.3.3
  PARTITION BY RANGE clause, 17.3.1
    for composite-partitioned tables, 17.3.4, 17.3.5
  PARTITION clause
    for composite-partitioned tables, 17.3.4, 17.3.5
    for hash partitions, 17.3.2
    for list partitions, 17.3.3
    for range partitions, 17.3.1
  partitioned indexes, 17
    adding partitions, 17.4.2.6
    creating local index on composite partitioned table, 17.3.4
    creating local index on hash partitioned table, 17.3.2.1
    creating range partitions, 17.3.1.2
    description, 17.1
    dropping partitions, 17.4.4.2
    global, 17.2
    local, 17.2
    maintenance operations, 17.4
    maintenance operations, table of, 17.4
    modifying partition default attributes, 17.4.7.3
    modifying real attributes of partitions, 17.4.8.4
    moving partitions, 17.4.12.3
    rebuilding index partitions, 17.4.14
    renaming index partitions/subpartitions, 17.4.15.3
    secondary indexes on index-organized tables, 17.3.10.1
    splitting partitions, 17.4.16.5
  partitioned tables, 17
    adding partitions, 17.4.2
    adding subpartitions, 17.4.2.4.2, 17.4.2.5.2
    coalescing partitions, 17.4.3
    creating hash partitions, 17.3.2
    creating list partitions, 17.3.3
    creating range partitions, 17.3.1, 17.3.1.2
    creating range-hash partitions, 17.3.4
    creating range-list partitions, 17.3.5
    description, 17.1
    DISABLE ROW MOVEMENT, 17.3
    dropping, 17.5
    dropping partitions, 17.4.4
    ENABLE ROW MOVEMENT, 17.3
    exchanging partitions, 17.4.5
    exchanging subpartitions, 17.4.5.3, 17.4.5.5
    global indexes on, 17.2
    index-organized tables, 17.3, 17.3.10.1, 17.3.10.2, 17.3.10.3
    local indexes on, 17.2
    maintenance operations, 17.4
    maintenance operations, table of, 17.4
    marking indexes UNUSABLE, 17.4.2.2, 17.4.3, 17.4.4.1, 17.4.4.2, 17.4.5, 17.4.6, 17.4.8.1, 17.4.8.1, 17.4.8.2, 17.4.12, 17.4.16, 17.4.17
    merging partitions, 17.4.6
    modifying default attributes, 17.4.7
    modifying real attributes of partitions, 17.4.8
    modifying real attributes of subpartitions, 17.4.8.3
    moving partitions, 17.4.12
    moving subpartitions, 17.4.12.2
    multicolumn partitioning keys, 17.3.7
    rebuilding index partitions, 17.4.14
    redefining partitions online, 15.7.7, 17.4.13
      rules for, 15.7.7.1
    renaming partitions, 17.4.15
    renaming subpartitions, 17.4.15.2
    splitting partitions, 17.4.16
    truncating partitions, 17.4.17
    truncating subpartitions, 17.4.17.2
    updating global indexes automatically, 17.4.1
  partitioning
    See also partitioned tables
    creating partitions, 17.3
    default partition, 17.2.3
    default subpartition, 17.2.5
    indexes, 17.1
    index-organized tables, 17.3, 17.3.10.1, 17.3.10.2, 17.3.10.3
    list, 17.2.3, 17.4.9, 17.4.10
    maintaining partitions, 17.4
    methods, 17.2
    range-hash, 17.2.4, 17.3.4
    range-list, 17.2.5, 17.3.5
    subpartition templates, 17.3.6
    tables, 17.1
  partitions
    See also partitioned tables.
    See also partitioned indexes.
  PARTITIONS clause
    for hash partitions, 17.3.2
  password file
    adding users, 1.7.3
    creating, 1.7.1
    ORAPWD utility, 1.7.1
    removing, 1.7.4.2
    setting REMOTE_LOGIN_PASSWORD, 1.7.2
    viewing members, 1.7.3.2
  password file authentication, 1.6.4.1
    for Automatic Storage Management, 12.3.2.2
  passwords
    default for SYS and SYSTEM, 1.5.2
    password file, 1.7.3
    setting REMOTE_LOGIN_PASSWORD parameter, 1.7.2
  patches, installing, 1.2.10
  PCTINCREASE parameter, 15.6.2
    altering, 14.3.7
  pending area for Database Resource Manager plans, 24.4.1, 24.4.1.4
    validating plan schema changes, 24.4.1.2
  pending transaction tables, 33.7.6
  performance
    index column order, 16.2.3
    location of datafiles and, 9.1.3
  plan schemas for Database Resource Manager, 24.1.4.2, 24.1.4.4.1, 24.4.1, 24.4.2.3, 24.6, 24.10
    examples, 24.7
    validating plan changes, 24.4.1.2
  PL/SQL
    replaced views and program units, 20.1.3
  PRAGMA_EXCEPTION_INIT procedure
    assigning exception names, 31.5
  prepare phase
    abort response, 32.3.1.1.3
    in two-phase commit, 32.3.1
    prepared response, 32.3.1.1.1
    read-only response, 32.3.1.1.2
    recognizing read-only nodes, 32.3.1.1.2
    steps, 32.3.1.2
  prepare/commit phases
    effects of failure, 33.8.1
    failures during, 33.4.1
    locked resources, 33.8
    pending transaction table, 33.7.6
  prepared response
    two-phase commit, 32.3.1.1.1
  prerequisites
    for creating a database, 2.2.1.2
  PRIMARY KEY constraints
    associated indexes, 16.3.3.1
    dropping associated indexes, 16.6
    enabling on creation, 16.3.3
    foreign key references when dropped, 13.5.3.1
    indexes associated with, 16.3.3
  priorities
    job, 28.2.12
  private database links, 29.2.6
  private synonyms, 20.3.1
  privileges
    adding redo log groups, 6.3
    altering indexes, 16.4
    altering tables, 15.6
    closing a database link, 31.2
    creating database links, 30.2.1
    creating tables, 15.3
    creating tablespaces, 8.2
    database administrator, 1.5
    dropping indexes, 16.6
    dropping online redo log members, 6.5.2
    dropping redo log groups, 6.5.1
    dropping tables, 15.10
    enabling and disabling triggers, 13.4
    for external tables, 15.13.4
    forcing a log switch, 6.6
    managing with procedures, 30.6.3.4
    managing with synonyms, 30.6.2.2
    managing with views, 30.6.1
    manually archiving, 7.3.3
    recompiling packages, 13.7.3
    recompiling procedures, 13.7.2
    recompiling views, 13.7.1
    renaming objects, 13.6
    renaming redo log members, 6.4
    RESTRICTED SESSION system privilege, 3.1.4.4
    Scheduler, 28.2.7
    sequences, 20.2.2, 20.2.2, 20.2.5
    synonyms, 20.3.2, 20.3.4
    taking tablespaces offline, 8.5.1
    truncating, 13.3.3
    using a view, 20.1.4
    using sequences, 20.2.4
    views, 20.1.2, 20.1.3, 20.1.7
  procedures
    external, 4.5
    location transparency in distributed databases, 30.6.3
    name resolution in distributed databases, 29.4.9
    recompiling, 13.7.2
    remote calls, 29.5.2
  process monitor (PMON), 4.3
  processes
    See also server processes
  PROCESSES initialization parameter
    setting before database creation, 2.4.6
  PRODUCT_COMPONENT_VERSION view, 1.4.2
  programs
    altering, 27.3.3
    creating, 27.3.2
    disabling, 27.3.5
    dropping, 27.3.4
    enabling, 27.3.6
    overview, 26.2.1
    using, 27.3
  public database links, 29.2.6
    connected user, 30.8.3
    fixed user, 30.8.1
  public fixed user database links, 30.8.1
  public synonyms, 20.3.1
  PURGE_LOST_DB_ENTRY procedure
    DBMS_TRANSACTION package, 33.6.1

## Q

  queries
    distributed, 29.4.2
    distributed application development issues, 31.4
    location transparency and, 29.5.1.2
    remote, 29.4.1
  quiescing a database, 3.4
  quotas
    tablespace, 8.1.2

## R

  RAISE_APPLICATION_ERROR() procedure, 31.5
  range partitioning
    creating tables using, 17.3.1
    index-organized tables, 17.3.10.1
    multicolumn partitioning keys, 17.3.7
  range-hash partitioning
    creating tables using, 17.3.4
    subpartitioning template, 17.3.6.1
    when to use, 17.2.4
  range-list partitioning
    creating tables using, 17.3.5
    subpartitioning template, 17.3.6.2
    when to use, 17.2.5
  read consistency
    managing in distributed databases, 33.10
  read-only database
    opening, 3.2.3
  read-only response
    two-phase commit, 32.3.1.1.2
  read-only tablespaces
    datafile headers when rename, 8.7
    delaying opening of datafiles, 8.6.4
    making read-only, 8.6.1
    making writable, 8.6.2
    WORM devices, 8.6.3
  Real Application Clusters
    allocating extents for cluster, 18.4
    sequence numbers and, 20.2.2
    threads of online redo log, 6.1.1
  rebalance
    tuning, 12.3.3.2
  REBALANCE NOWAIT clause, 12.4.3
  REBALANCE WAIT clause, 12.4.3
  rebalancing a disk group, 12.4.3.5
  REBUILD PARTITION clause, 17.4.12.3, 17.4.14.2.1, 17.4.14.2.1
  REBUILD UNUSABLE LOCAL INDEXES clause, 17.4.14.2.2
  rebuilding indexes, 16.4.2
    costs, 16.2.10
    online, 16.4.2
  reclaiming unused space, 14.5
  RECOVER clause
    STARTUP command, 3.1.4.6
  recoverer process
    disabling, 33.9.2
    distributed transaction recovery, 33.9.2
    enabling, 33.9.2
    pending transaction table, 33.9.2
  recoverer process (RECO), 4.3
  recovering
    Scheduler jobs, 28.2.11
  recovery
    creating new control files, 5.3.3.2
  Recovery Manager
    starting a database, 3.1.1.2
    starting an instance, 3.1.1.2
  recycle bin
    about, 15.11.1
    purging, 15.11.4
    renamed objects, 15.11.1
    restoring objects from, 15.11.5
    viewing, 15.11.3
  redefining tables online
    See online redefinition of tables
  redo log files
    See also online redo logs
    active (current), 6.1.3.1
    archiving, 7.2
    available for use, 6.1.3
    circular use of, 6.1.3
    clearing, 6.2.1.1, 6.8
    contents of, 6.1.2
    creating as Oracle-managed files, 11.3.6
    creating as Oracle-managed files, example, 11.5.1
    creating groups, 6.3
    creating members, 6.3, 6.3.2
    distributed transaction information in, 6.1.3
    dropping groups, 6.5
    dropping members, 6.5
    group members, 6.2.1
    groups, defined, 6.2.1
    how many in redo log, 6.2.4
    inactive, 6.1.3.1, 6.1.3.1
    instance recovery use of, 6.1
    legal and illegal configurations, 6.2.1.2
    LGWR and the, 6.1.3
    log switches, 6.1.3.2
    maximum number of members, 6.2.4
    members, 6.2.1
    mirrored, log switches and, 6.2.1.1
    multiplexed, 6.2.1, 6.2.1, 6.2.1.1
    online, defined, 6.1
    planning the, 6.2, 6.2.4
    redo entries, 6.1.2
    requirements, 6.2.1.2
    storing separately from datafiles, 9.1.4
    threads, 6.1.1
    unavailable when database is opened, 3.1.4
    verifying blocks, 6.7
  redo logs
    See also online redo log
    creating in Automatic Storage Management, 12.5.7
  redo records, 6.1.2
    LOGGING and NOLOGGING, 8.4
  REDUNDANCY_LOWERED column
    in V$ASM_FILE, 12.4.1.6
  referential integrity
    distributed database application development, 31.3
  release number format, 1.4.1
  releases, 1.4.1
    checking the Oracle Database release number, 1.4.2
  relocating control files, 5.3.2
  remote connections
    connecting as SYSOPER/SYSDBA, 1.6.1
    password files, 1.7.2
  remote data
    querying, 30.7
    updating, 30.7
  remote procedure calls, 29.5.2, 29.5.2
    distributed databases and, 29.5.2
  remote queries
    distributed databases and, 29.4.1
  remote transactions, 29.4.4
    defined, 29.4.4
  REMOTE_LOGIN_PASSWORDFILE initialization parameter, 1.7.2
  REMOTE_OS_AUTHENT initialization parameter
    connected user database links, 29.2.7.1
  RENAME PARTITION clause, 17.4.15.1, 17.4.15.2, 17.4.15.3.1
  RENAME statement, 13.6
  renaming control files, 5.3.2
  renaming files
    Oracle-managed files, 11.4.3
  REOPEN attribute
    LOG_ARCHIVE_DEST_n initialization parameter, 7.6.2
  repair table
    example of building, 21.4.1.1
  repairing data block corruption
    DBMS_REPAIR, 21.1
  repeat interval, schedule, 27.4.5
  RESIZE clause
    for single-file tablespace, 8.2.2.2
  resizing disks in disk groups, 12.4.3.3
  resource allocation methods, 24.1.3
    active session pool, 24.4.2
    ACTIVE_SESS_POOL_MTH, 24.4.2
    CPU resource, 24.4.2
    EMPHASIS, 24.4.2
    limit on degree of parallelism, 24.4.2
    PARALLEL_DEGREE_LIMIT_ABSOLUTE, 24.4.2
    PARALLEL_DEGREE_LIMIT_MTH, 24.4.2
    QUEUEING_MTH, 24.4.2
    queuing resource allocation method, 24.4.2
    ROUND-ROBIN, 24.4.3
  resource consumer groups, 24.1.3
    changing, 24.5.2
    creating, 24.4.3
    DEFAULT_CONSUMER_GROUP, 24.4.3, 24.4.3.3, 24.5.3.2
    deleting, 24.4.3.3
    granting the switch privilege, 24.5.3
    LOW_GROUP, 24.4.3, 24.7.3
    managing, 24.5, 24.5.2.3
    OTHER_GROUPS, 24.1.4.2, 24.4.1.2, 24.4.3, 24.4.4.1, 24.7.3
    parameters, 24.4.3
    revoking the switch privilege, 24.5.3.2
    setting initial, 24.5.1
    switching a session, 24.5.2.1
    switching sessions for a user, 24.5.2.2
    SYS_GROUP, 24.4.3, 24.7.3
    updating, 24.4.3.2
  Resource Manager
    AUTO_TASK_CONSUMER_GROUP consumer group, 23.3
  resource plan directives, 24.1.3, 24.4.1.2
    deleting, 24.4.4.3
    specifying, 24.4.4
    updating, 24.4.4.2
  resource plans, 24.1.3, 24.1.4.2
    creating, 24.3
    DELETE_PLAN_CASCADE, 24.4.2.3
    deleting, 24.4.2.3
    examples, 24.1.4.1, 24.7
    parameters, 24.4.2
    plan schemas, 24.1.4.2, 24.1.4.4.1, 24.4.1, 24.4.2.3, 24.6, 24.10
    subplans, 24.1.4.2, 24.1.4.2, 24.4.2.3
    SYSTEM_PLAN, 24.4.2, 24.4.3, 24.7.3
    top plan, 24.4.1.2, 24.6
    updating, 24.4.2.2
    validating, 24.4.1.2
  RESOURCE_MANAGER_PLAN initialization parameter, 24.6, 24.6
  RESTRICTED SESSION system privilege
    restricted mode and, 3.1.4.4
  resumable space allocation
    correctable errors, 14.4.1.3
    detecting suspended statements, 14.4.4
    disabling, 14.4.2
    distributed databases, 14.4.1.4
    enabling, 14.4.2
    example, 14.4.6
    how resumable statements work, 14.4.1.1
    naming statements, 14.4.2.2.2
    parallel execution and, 14.4.1.5
    resumable operations, 14.4.1.2
    setting as default for session, 14.4.3
    timeout interval, 14.4.2.2.1, 14.4.4.1
  RESUMABLE_TIMEOUT Initialization Parameter
    setting, 14.4.2.1
  RESUMABLE_TIMEOUT initialization parameter, 14.4.1.1
  RMAN. See Recovery Manager.
  roles
    DBA role, 1.5.2.3
    obtained through database links, 29.2.10
  ROLLBACK statement
    FORCE clause, 33.5, 33.5.1.1, 33.5.2
    forcing, 33.4.2
  rollbacks
    ORA-02, 31.3
  ROUND-ROBIN resource allocation method, 24.4.3
  row movement clause for partitioned tables, 17.3
  rows
    listing chained or migrated, 13.2.3
  rules
    adding to a chain, 27.9.4
    dropping from chains, 27.9.9
  running
    chains, 27.9.8
    jobs, 27.2.5

## S

  Sample Schemas
    description, 2.9.4
  savepoints
    in-doubt transactions, 33.5, 33.5.2
  Scheduler
    administering, 28
    architecture, 26.4
    configuring, 28.1
    examples of using, 28.4
    GATHER_STATS_JOB job, 23.2
    GATHER_STATS_PROG program, 23.2
    import and export, 28.3
    maintenance windows, 23.1
    monitoring and managing, 28.2
    overview, 26.1
    privileges, 28.2.3, 28.2.7
    security, 28.2.17
    statistics collection, 23.2
    using, 27
    using in RAC, 26.4.5
    views, 28.2.1
  Scheduler objects, naming, 27.1
  schedules
    altering, 27.4.3
    creating, 27.4.2
    dropping, 27.4.4
    overview, 26.2.2
    using, 27.4
  schema objects
    analyzing, 13.2
    creating multiple objects, 13.1
    defining using DBMS_METADATA package, 13.10.1
    dependencies between, 13.7
    distributed database naming conventions for, 29.2.9.4
    global names, 29.2.9.4
    listing by type, 13.10.2.1
    name resolution in distributed databases, 29.2.9.4, 29.4.8
    name resolution in SQL statements, 13.8
    privileges to rename, 13.6
    referencing with synonyms, 30.6.2.1
    renaming, 13.6, 13.6
    validating structure, 13.2.2
    viewing information, 13.10, 14.7
  SCN. See system change number.
  SCOPE clause
    ALTER SYSTEM SET, 2.7.5.1
  scripts, authenticating users in, 2.9.3
  security
    accessing a database, 22.1
    administrator of, 22.1
    centralized user management in distributed databases, 29.3.2.4
    database security, 22.1
    distributed databases, 29.3.2
    establishing policies, 22
    privileges, 22.1
    remote objects, 30.6.1
    Scheduler, 28.2.17
    using synonyms, 30.6.2.2
  Segment Advisor, 14.5.2
    configuring Scheduler job, 14.5.2.4
    invoking with Enterprise Manager, 14.5.2.2.1
    invoking with PL/SQL, 14.5.2.2.2
    running manually, 14.5.2.2
    viewing results, 14.5.2.3
    views, 14.5.2.5
  SEGMENT_FIX_STATUS procedure
    DBMS_REPAIR, 21.2.1
  segments
    available space, 14.7.1
    data dictionary views for, 14.7.2
    deallocating unused space, 14.5
    displaying information on, 14.7.2.1
    shrinking, 14.5.3
    storage parameters for temporary, 14.3.8
  SELECT statement
    FOR UPDATE clause and location transparency, 30.7
  selecting an instance with environment variables, 1.3
  SEQUENCE_CACHE_ENTRIES parameter, 20.2.4.2.2
  sequences
    accessing, 20.2.4
    altering, 20.2.3
    caching sequence numbers, 20.2.4.2
    creating, 20.2.2, 20.2.4.2.2, 20.2.4.2.2
    CURRVAL, 20.2.4.1.2
    dropping, 20.2.5
    managing, 20.2.1
    NEXTVAL, 20.2.4.1.1
    Oracle Real Applications Clusters and, 20.2.2
  SERVER parameter
    net service name, 30.3.3.1
  server parameter file
    and Automatic Storage Management, 3.1.2
    creating, 2.7.3
    defined, 2.7.1
    error recovery, 2.7.8
    exporting, 2.7.6
    migrating to, 2.7.2
    RMAN backup, 2.7.7
    setting initialization parameter values, 2.7.5
    SPFILE initialization parameter, 2.7.4
    STARTUP command behavior, 2.7.1
    viewing parameter settings, 2.7.9
  server processes
    archiver (ARCn), 4.3
    background, 4.3
    checkpoint (CKPT), 4.3
    database writer (DBWn), 4.3
    dedicated, 4.1.1
    dispatcher (Dnnn), 4.3
    dispatchers, 4.2.3.3
    global cache service (LMS), 4.3
    log writer (LGWR), 4.3
    monitoring, 4.7
    monitoring locks, 4.7.3
    process monitor (PMON), 4.3
    recoverer (RECO), 4.3
    shared server, 4.1.2
    system monitor (SMON), 4.3
    trace files for, 4.7.2
  server-generated alerts, 4.7.1
  servers
    role in two-phase commit, 32.2.2
  service names
    database links and, 30.2.4
  services
    application, 2.8
    application, configuring, 2.8.2
    application, deploying, 2.8.1
    application, using, 2.8.3
  session trees for distributed transactions
    clients, 32.2.1
    commit point site, 32.2.5, 32.2.5.2
    database servers, 32.2.2
    definition, 32.2
    global coordinators, 32.2.4
    local coordinators, 32.2.3
    tracing transactions, 33.3.2
  sessions
    active, 4.6.2
    inactive, 4.6.3
    setting advice for transactions, 33.4.3.3
    terminating, 4.6
  SET TIME_ZONE clause
    ALTER SESSION, 2.3.9.1
    CREATE DATABASE, 2.3.9.1
  SET TRANSACTION statement
    naming transactions, 33.2
  SGA
    See Also system global area
  SGA. See system global area.
  SGA_MAX_SIZE initialization parameter, 2.4.5
    setting size, 2.4.5.2
  shared database links
    configuring, 30.3.3
    creating, 30.3.2
    dedicated servers, creating links to, 30.3.3.1
    determining whether to use, 30.3.1
    example, 29.2.8
    shared servers, creating links to, 30.3.3.2
  SHARED keyword
    CREATE DATABASE LINK statement, 30.3.2
  shared server, 4.1.2
    configuring dispatchers, 4.2.3
    disabling, 4.2.2.2, 4.2.3.6
    initialization parameters, 4.2.1
    interpreting trace output, 4.7.2.5
    setting minimum number of servers, 4.2.2.2
    trace files for processes, 4.7.2
    views, 4.2.4
  shared SQL
    for remote and distributed statements, 29.4.3
  shrinking segments online, 14.5.3
  SHUTDOWN command
    ABORT clause, 3.3.4
    IMMEDIATE clause, 3.3.2
    NORMAL clause, 3.3.1
    TRANSACTIONAL clause, 3.3.3
  Simple Network Management Protocol (SNMP) support
    database management, 29.3.4.3
  single-file tablespaces
    description, 8.2.2
  single-table hash clusters, 19.3.2
  site autonomy
    distributed databases, 29.3.1
  SKIP_CORRUPT_BLOCKS procedure, 21.3.3.1
    DBMS_REPAIR, 21.2.1
    example, 21.4.5
  SORT_AREA_SIZE initialization parameter
    index creation and, 16.2.1
  space
    deallocating unused, 14.5.4
    reclaiming unused, 14.5
  space allocation
    resumable, 14.4
  space management
    data blocks, 14.2
    datatypes, space requirements, 14.6
    deallocating unused space, 14.5
    Segment Advisor, 14.5
    setting storage parameters, 14.3.1, 14.3.7
    shrink segment, 14.5
  SPACE_ERROR_INFO procedure, 14.4.4.1
  SPFILE initialization parameter, 2.7.4
    specifying from client machine, 3.1.2
  SPLIT PARTITION clause, 17.4.2.1, 17.4.16
  SQL statements
    distributed databases and, 29.4.1
  SQL*Loader
    about, 1.8.2.1
  SQL*Plus
    starting, 3.1.3
    starting a database, 3.1.1.1
    starting an instance, 3.1.1.1
  SQL_TRACE initialization parameter
    trace files and, 4.7.2
  STALE status
    of redo log members, 6.5.2
  stalled chain (Scheduler), 27.9.13
  standby transmission mode
    definition of, 7.5.2
    Oracle Net and, 7.5.2
    RFS processes and, 7.5.2
  starting
    Automatic Storage Management instance, 12.5.3
  starting a database, 3.1
    forcing, 3.1.4.5
    Oracle Enterprise Manager, 3.1.1.3
    recovery and, 3.1.4.6
    Recovery Manager, 3.1.1.2
    restricted mode, 3.1.4.4
    SQL*Plus, 3.1.1.1
    when control files unavailable, 3.1.4
    when redo logs unavailable, 3.1.4
  starting an instance
    automatically at system startup, 3.1.4.7
    database closed and mounted, 3.1.4.3
    database name conflicts and, 2.4.1.1
    forcing, 3.1.4.5
    mounting and opening the database, 3.1.4.1
    normally, 3.1.4.1
    Oracle Enterprise Manager, 3.1.1.3
    recovery and, 3.1.4.6
    Recovery Manager, 3.1.1.2
    remote instance startup, 3.1.4.8
    restricted mode, 3.1.4.4
    SQL*Plus, 3.1.1.1
    when control files unavailable, 3.1.4
    when redo logs unavailable, 3.1.4
    without mounting a database, 3.1.4.2
  STARTUP command
    default behavior, 2.7.1
    NOMOUNT clause, 2.2.2.6, 3.1.4.2
    RECOVER clause, 3.1.4.6
    starting a database, 3.1.1.1, 3.1.4
  statement transparency in distributed database
    managing, 30.7
  statistics
    automatically collecting for tables, 15.5
  statistics collection
    using Scheduler, 23.2
  STATISTICS_LEVEL initialization parameter
    automatic statistics collection, 15.5
  steps, chain
    altering, 27.9.12
    dropping, 27.9.11
  stopping
    jobs, 27.2.6
  STORAGE clause
    See also storage parameters
  storage parameters
    applicable objects, 14.3
    BUFFER POOL, 14.3.1
    INITIAL, 14.3.1, 15.6.2
    INITRANS, altering, 15.6.2
    MAXTRANS, altering, 15.6.2
    MINEXTENTS, 14.3.1, 15.6.2
    NEXT, 15.6.2
    PCTINCREASE, 15.6.2
    precedence of, 14.3.8
    setting, 14.3.1
    temporary segments, 14.3.8
  storage subsystems
    mapping files to physical devices, 9.9, 9.9.4.3
  STORE IN clause, 17.3.4
  stored procedures
    managing privileges, 30.6.3.4
    privileges for recompiling, 13.7.2
    remote object security, 30.6.3.4
  SUBPARTITION BY HASH clause
    for composite-partitioned tables, 17.3.4
  SUBPARTITION BY LIST clause
    for composite-partitioned tables, 17.3.5
  SUBPARTITION clause, 17.4.2.4.1, 17.4.2.5.1, 17.4.16.3
    for composite-partitioned tables, 17.3.4, 17.3.5
  subpartition templates, 17.3.6
    modifying, 17.4.11
  subpartitions, 17.1
  SUBPARTITIONS clause, 17.4.2.4.1, 17.4.16.3
    for composite-partitioned tables, 17.3.4
  subqueries
    in remote updates, 29.4.1
    statement transparency in distributed databases, 30.7
  SunSoft SunNet Manager, 29.3.4.3
  SWITCH LOGFILE clause
    ALTER SYSTEM statement, 6.6
  synonyms, 20.3.3
    creating, 20.3.2, 30.6.2.1
    definition and creation, 30.6.2.1
    displaying dependencies of, 13.10.2.2
    dropping, 20.3.4
    examples, 30.6.2.1
    location transparency in distributed databases, 30.6.2
    managing, 20.3.1, 20.3.4
    managing privileges in remote database, 30.6.2.2
    name resolution in distributed databases, 29.4.9
    private, 20.3.1
    public, 20.3.1
    remote object security, 30.6.2.2
  SYS account
    default password, 1.5.2
    objects owned, 1.5.2.1
    privileges, 1.5.2.1
    specifying password for CREATE DATABASE statement, 2.3.1
  SYS_GROUP for Database Resource Manager, 24.4.3, 24.7.3
  SYSAUX tablespace, 8.2
    about, 2.3.3
    cannot rename, 8.7
    creating at database creation, 2.2.2.7, 2.3.3
    DATAFILE clause, 2.3.3
    monitoring occupants, 8.9.1
    moving occupants, 8.9.2
  SYSDBA system privilege
    adding users to the password file, 1.7.3
    connecting to database, 1.6.1.1
    determining who has privileges, 1.7.3.2
    granting and revoking, 1.7.3.1
  SYSOPER system privilege
    adding users to the password file, 1.7.3
    connecting to database, 1.6.1.1
    determining who has privileges, 1.7.3.2
    granting and revoking, 1.7.3.1
  SYSTEM account
    default password, 1.5.2
    objects owned, 1.5.2.2
    specifying password for CREATE DATABASE, 2.3.1
  system change numbers
    coordination in a distributed database system, 32.3.2.2
    in-doubt transactions, 33.5.1.2
    using V$DATAFILE to view information about, 9.10
    when assigned, 6.1.2
  system global area
    holds sequence number cache
    initialization parameters affecting size, 2.4.5
    specifying buffer cache sizes, 2.4.5.4.1
  system monitor process (SMON), 4.3
  system privileges
    ADMINISTER_RESOURCE_MANAGER, 24.2
    for external tables, 15.13.4
  SYSTEM tablespace
    cannot rename, 8.7
    creating at database creation, 2.2.2.7
    creating locally managed, 2.2.2.7, 2.3.2
    restrictions on taking offline, 9.4
    when created, 8.2
  SYSTEM_PLAN for Database Resource Manager, 24.4.2, 24.4.3, 24.7.3

## T

  tables
    about, 15.1
    adding columns, 15.6.6
    allocating extents, 15.6.4
    altering, 15.6.1
    altering physical attributes, 15.6.2
    analyzing, 13.2
    clustered (hash). See hash clusters
    creating, 15.3
    designing before creating, 15.2.1
    dropping, 15.10
    dropping columns, 15.6.8
    estimating size, 15.2.7
    estimating space use, 14.8.1
    external, 15.13
    Flashback Drop, 15.11
    Flashback Table, 15.9
    Flashback Transaction Query, 15.8
    guidelines for managing, 15.2
    hash clustered. See hash clusters
    increasing column length, 15.6.5
    index-organized, 15.12
    index-organized, partitioning, 17.3.10
    key-preserved, 20.1.5.1
    limiting indexes on, 16.2.4
    managing, 15
    modifying column definition, 15.6.5
    moving, 15.6.3
    moving time windows in historical, 17.6
    parallelizing creation, 15.2.4, 15.3.3
    partitioned, 17.1
    redefining online, 15.7
    renaming columns, 15.6.7
    restrictions when creating, 15.2.8
    setting storage parameters, 15.2.7
    shrinking, 14.5.3
    specifying location, 15.2.3
    statistics collection, automatic, 15.5
    temporary, 15.3.2
    truncating, 13.3
    unrecoverable (NOLOGGING), 15.2.5
    validating structure, 13.2.2
    views, 15.14
  tablespace set, 8.12.5.2
  tablespaces
    adding datafiles, 9.2
    assigning user quotas, 8.1.2
    automatic segment space management, 8.2.1.2
    bigfile, 2.3.8, 8.2.2
    checking default storage parameters, 8.13.1
    containing XMLTypes, 8.12.3
    creating in Automatic Storage Management, 12.5.6
    creating undo tablespace at database creation, 2.3.4, 2.3.8.2
    DBMS_SPACE_ADMIN package, 8.10
    default temporary tablespace, creating, 2.3.6, 2.3.8.2
    detecting and repairing defects, 8.10
    diagnosing and repairing problems in locally managed, 8.10
    dictionary managed, 8.2.2.3
    dropping, 8.8
    guidelines for managing, 8.1
    listing files of, 8.13.2
    listing free space in, 8.13.3
    locally managed, 8.2.1
    locally managed SYSTEM, 2.3.2
    locally managed temporary, 8.2.3.1
    location, 9.1.3
    migrating SYSTEM to locally managed, 8.11
    multiple block sizes, 8.12.5.5
    on a WORM device, 8.6.3
    Oracle-managed files, managing, 11.5.1, 11.5.2
    overriding default type, 2.3.8.2
    quotas, assigning, 8.1.2
    read-only, 8.6
    renaming, 8.7
    setting default type, 2.3.8.1
    single-file, 2.3.8, 2.3.8.2, 8.2.2, 8.2.2.2
    specifying nonstandard block sizes, 8.3
    SYSAUX, 8.2, 8.7
    SYSAUX creation, 2.3.3
    SYSAUX, managing, 8.9
    SYSTEM, 8.2, 8.2.1, 8.6.1, 8.11
    taking offline normal, 8.5.1
    taking offline temporarily, 8.5.1
    tempfiles in locally managed, 8.2.3.1
    temporary, 8.2.3, 8.2.4.3
    temporary bigfile, 8.2.3.2
    temporary for creating large indexes, 16.3.5
    transportable
      see transportable tablespaces
    undo, 10.1
    using multiple, 8.1.1
    using Oracle-managed files, 11.3.3
  tempfiles, 8.2.3.1
    creating as Oracle-managed, 11.3.4
    dropping, 9.6
    dropping Oracle-managed tempfiles, 11.4.1
  template
    dropping an Automatic Storage Management, 12.4.10.3
    managing Automatic Storage Management, 12.4.10
    modifying an Automatic Storage Management, 12.4.10.2
  temporary segments
    index creation and, 16.2.1
  temporary tables
    creating, 15.3.2
  temporary tablespaces
    altering, 8.2.3.3
    bigfile, 8.2.3.2
    creating, 8.2.3.1
    groups, 8.2.4
    renaming default, 8.7
  terminating user sessions
    active sessions, 4.6.2
    identifying sessions, 4.6.1
    inactive session, example, 4.6.3
    inactive sessions, 4.6.3
  threads
    online redo log, 6.1.1
  threshold based alerts
    managing with Oracle Enterprise Manager, 4.7.1
  threshold-based alerts
    server-generated, 4.7.1
  thresholds
    setting alert, 14.1.1
  time zone
    files, 2.3.9.2
    setting for database, 2.3.9.1
  TNSNAMES.ORA file, 7.4.1.1
  trace files
    location of, 4.7.2.2
    log writer process and, 6.2.1.1
    size of, 4.7.2.3
    using, 4.7.2, 4.7.2.1
    when written, 4.7.2.4
  tracing
    archivelog process, 7.7
  transaction control statements
    distributed transactions and, 32.1.2
  transaction failures
    simulating, 33.9
  transaction management
    overview, 32.3
  transaction processing
    distributed systems, 29.4
  transactions
    closing database links, 31.2
    distributed and two-phase commit, 29.4.6
    in-doubt, 32.3.1.2, 32.4, 32.4.3, 33.4
    naming distributed, 33.2, 33.4.3.2
    remote, 29.4.4
  transmitting archived redo logs, 7.5
  transparent data encryption, 2.9.2
  transportable tablespaces, 8.12
    compatibility considerations, 8.12.4
    from backup, 8.12.1
    limitations, 8.12.3
    multiple block sizes, 8.12.5.5
    procedure, 8.12.5
    when to use, 8.12.6
    wizard in Enterprise Manager, 8.12.1
    XMLTypes in, 8.12.3
  transporting tablespaces between databases, 8.12
  triggers
    disabling, 13.4.2
    enabling, 13.4.1
  TRUNCATE PARTITION clause, 17.4.17, 17.4.17, 17.4.17.1, 17.4.17.1.1, 17.4.17.1.1
  TRUNCATE statement, 13.3.3
    DROP STORAGE clause, 13.3.3
    REUSE STORAGE clause, 13.3.3
    vs. dropping table, 15.10
  TRUNCATE SUBPARTITION clause, 17.4.17.2
  tuning
    analyzing tables, 31.4.2.2.2
    cost-based optimization, 31.4.2
  two-phase commit
    case study, 32.5
    commit phase, 32.3.2, 32.5.4
    described, 29.4.6
    discovering problems with, 33.4.1
    distributed transactions, 32.3
    example, 32.5
    forget phase, 32.3.3
    in-doubt transactions, 32.4, 32.4.3
    phases, 32.3
    prepare phase, 32.3.1, 32.3.1.2
    recognizing read-only nodes, 32.3.1.1.2
    specifying commit point strength, 33.1
    steps in commit phase, 32.3.2.1
    tracing session tree in distributed transactions, 33.3.2
    viewing database links, 33.3.1

## U

  undo retention, 10.2.2
    automatic tuning of, 10.2.2.1
    guaranteeing, 10.3.3.2
    setting, 10.3.3
    setting UNDO_RETENTION initialization parameter, 10.3.3.1
  undo segments
    in-doubt distributed transactions, 33.4.2
  undo space management
    automatic undo management mode, 10.2
    described, 10.1
  undo tablespace
    initialization parameters for, 10.2.1
    managing, 10
  undo tablespaces
    altering, 10.4.2
    creating, 10.4.1
    dropping, 10.4.3
    monitoring, 10.6
    PENDING OFFLINE status, 10.4.4
    renaming, 8.7
    specifying at database creation, 2.2.2.7, 2.3.4, 2.3.8.2
    starting an instance using, 10.2.1
    statistics for, 10.6
    switching, 10.4.4
    user quotas, 10.4.5
    viewing information about, 10.6
  UNDO_MANAGEMENT initialization parameter, 2.3.4
    starting instance as AUTO, 10.2.1
  UNDO_RETENTION initialization parameter
    setting, 10.3.3.1
  UNDO_TABLESPACE initialization parameter
    for undo tablespaces, 2.4.7.2
    starting an instance using, 10.2.1
  undropping disks in disk groups, 12.4.3.4
  UNIQUE key constraints
    associated indexes, 16.3.3.1
    dropping associated indexes, 16.6
    enabling on creation, 16.3.3
    foreign key references when dropped, 13.5.3.1
    indexes associated with, 16.3.3
  UNRECOVERABLE DATAFILE clause
    ALTER DATABASE statement, 6.8
  UPDATE GLOBAL INDEX clause
    of ALTER TABLE, 17.4.1
  updates
    location transparency and, 29.5.1.2
  upgrading a database, 2.1
  USER_DB_LINKS view, 30.5.1, 30.5.1
  USER_DUMP_DEST initialization parameter, 4.7.2.2
  USER_RESUMABLE view, 14.4.4.1
  usernames
    SYS and SYSTEM, 1.5.2
  users
    assigning tablespace quotas, 8.1.2
    in a newly created database, 2.9.1
    limiting number of, 2.4.9
    session, terminating, 4.6.3
  utilities
    export, 1.8.2.2
    for the database administrator, 1.8.2
    import, 1.8.2.2
    SQL*Loader, 1.8.2.1
  UTLCHAIN.SQL script
    listing chained rows, 13.2.3.1
  UTLCHN1.SQL script
    listing chained rows, 13.2.3.1
  UTLLOCKT.SQL script, 4.7.3

## V

  V$ARCHIVE view, 7.8
  V$ARCHIVE_DEST view
    obtaining destination status, 7.4.2
  V$BLOCKING_QUIESCE view, 3.4.1, 24.10
  V$DATABASE view, 7.8.1
  V$DBLINK view, 30.5.2
  V$DISPATCHER view
    monitoring shared server dispatchers, 4.2.3.4
  V$DISPATCHER_RATE view
    monitoring shared server dispatchers, 4.2.3.4
  V$INSTANCE view
    for database quiesce state, 3.4.3
  V$LOG view, 7.8
    displaying archiving status, 7.8
    online redo log, 6.9
    viewing redo data with, 6.9
  V$LOG_HISTORY view
    viewing redo data, 6.9
  V$LOGFILE view
    log file status, 6.5.2
    viewing redo data, 6.9
  V$OBJECT_USAGE view
    for monitoring index usage, 16.4.3
  V$PWFILE_USERS view, 1.7.3.2
  V$QUEUE view
    monitoring shared server dispatchers, 4.2.3.4
  V$ROLLSTAT view
    undo segments, 10.6
  V$SESSION view, 4.6.3
  V$SYSAUX_OCCUPANTS view
    occupants of SYSAUX tablespace, 8.9.2
  V$THREAD view, 6.9
  V$TIMEZONE_NAMES view
    time zone table information, 2.3.9.2
  V$TRANSACTION view
    undo tablespaces information, 10.6
  V$UNDOSTAT view
    statistics for undo tablespaces, 10.6
  V$VERSION view, 1.4.2
  VALIDATE STRUCTURE clause
    of ANALYZE statement, 13.2.2
  VALIDATE STRUCTURE ONLINE clause
    of ANALYZE statement, 13.2.2
  varrays
    storage parameters for, 14.3.6
  verifying blocks
    redo log files, 6.7
  viewing
    alerts, 14.1.2
  views, 6.9
    creating, 20.1.2
    creating with errors, 20.1.2.3
    Database Resource Manager, 24.10
    DATABASE_PROPERTIES, 2.3.6
    DBA_2PC_NEIGHBORS, 33.3.2
    DBA_2PC_PENDING, 33.3.1
    DBA_DB_LINKS, 30.5.1
    DBA_RESUMABLE, 14.4.4.1
    displaying dependencies of, 13.10.2.2
    dropping, 20.1.7
    file mapping views, 9.9.3.3
    for monitoring datafiles, 9.10
    FOR UPDATE clause and, 20.1.2
    invalid, 20.1.4
    join. See join views.
    location transparency in distributed databases, 30.6.1
    managing, 20.1, 20.1.3
    managing privileges with, 30.6.1
    name resolution in distributed databases, 29.4.9
    ORDER BY clause and, 20.1.2
    remote object security, 30.6.1
    restrictions, 20.1.4
    tables, 15.14
    tablespace information, 8.13
    USER_RESUMABLE, 14.4.4.1
    using, 20.1.4
    V$ARCHIVE, 7.8
    V$ARCHIVE_DEST, 7.4.2
    V$DATABASE, 7.8.1
    V$LOG, 6.9, 6.9, 7.8
    V$LOG_HISTORY, 6.9
    V$LOGFILE, 6.5.2, 6.9
    V$OBJECT_USAGE, 16.4.3
    wildcards in, 20.1.2.2
    WITH CHECK OPTION, 20.1.2

## W

  WAIT keyword, in REBALANCE clause, 12.4.3
  wildcards
    in views, 20.1.2.2
  window groups
    creating, 27.7.2
    disabling, 27.7.7
    dropping, 27.7.3
    dropping a member from, 27.7.5
    enabling, 27.7.6
    overview, 26.3.3
    using, 27.7
  window logs, 27.6
  windows (Scheduler)
    altering, 27.6.3
    closing, 27.6.5
    creating, 27.6.2
    disabling, 27.6.7
    dropping, 27.6.6
    enabling, 27.6.8
    opening, 27.6.4
    overlapping, 27.6.9
    overview, 26.3.2
    using, 27.6
  WORM devices
    and read-only tablespaces, 8.6.3
  WRH$_UNDOSTAT view, 10.6

## X

  XML DB
    virtual folder for Automatic Storage Management, 12.7
  XMLTypes
    in transportable tablespaces, 8.12.3